Project:
| View Revisions: Issue #39148 | [ Back to Issue ] | ||
| Summary | 0039148: Data is not shown in report. An error is raised | ||
| Revision | 2018-08-23 16:13 by caristu | ||
| Steps To Reproduce | With Multi-Dimensional Profit and Loss Module installed Log in as System Administrator Go to Cube Definition Window and select the record with the name: DPL - P&L Template Click on Generate Cubes and select F&B International Group as the Client Click on Done Log out and log in as F&B Admin Go to Cube Definition Window and select the record with the name: DPL - P&L - F&B International Group US_A_US Dollar Move to Cube Reports || Cube Report Dimension || Cube Report Dimension Element and add a new record with: - Show: Member and Children - Account: PL - Profit & Loss - Exclude: No Go to process request window and create a new record with: - Client: F&B International Group - Organization: * - Process: Update Time Dimension Refs + Tree Closure Table - Timing: Run Immediately Schedule the process and wait until it finishes successfully (~1min 15 secs) Create another record with: - Client: F&B International Group - Organization: * - Process: Generate Profit And Loss Fact Acct - Timing: Run Immediately Schedule the process and wait until it finishes successfully (~2 mins) Go to Multi-Dimensional Profit And Loss Window and select: - Organization: F&B US - General Ledger: F&B International Group US/A/US Dollar - Year: 2017 Click on Done A Pop Up is shown with Error Loading Query. In the Log: Caused by: org.saiku.olap.util.exception.QueryParseException: Unable to find a member with name [[organization], [0], [19404EAD144C49A0AF37D54377CF452D], [2E60544D37534C0B89E765FE29BC0B43]] |
||
| Revision | 2018-08-23 16:09 by caristu | ||
| Steps To Reproduce | With Multi-Dimensional Profit and Loss Module installed Log in as System Administrator Go to Cube Definition Window and select the record with the name: DPL - P&L Template Click on Generate Cubes and select F&B International Group as the Client Click on Done Log out and log in as F&B Admin Go to Cube Definition Window and select the record with the name: DPL - P&L - F&B International Group US_A_US Dollar Move to Cube Reports || Cube Report Dimension || Cube Report Dimension Element and add a new record with: - Show: Member and Children - Account: PL - Profit & Loss - Exclude: No Go to process request window and create a new record with: - Client: F&B International Group - Organization: * - Process: Update Time Dimension Refs + Tree Closure Table - Timing: Run Immediately Schedule the process and wait until it finishes successfully (~1min 15 secs) Create another record with: - Client: F&B International Group - Organization: * - Process: Generate Profit And Loss Fact Acct - Timing: Run Immediately Schedule the process and wait until it finishes successfully (~2 mins) Go to Multi-Dimensional Profit And Loss Window and select: - Organization: F&B US - General Ledger: F&B International Group US/A/US Dollar - Year: 2018 Click on Done A Pop Up is shown with Error Loading Query. In the Log: Caused by: org.saiku.olap.util.exception.QueryParseException: Unable to find a member with name [[organization], [0], [19404EAD144C49A0AF37D54377CF452D], [2E60544D37534C0B89E765FE29BC0B43]] |
||
| Revision | 2018-08-17 10:44 by dmiguelez | ||
| Description | Data is not shown in report. An error is raised, making the report unusable. It seems to be a problem on how the dimension is created, before it was: [organization].[0].[19404EAD144C49A0AF37D54377CF452D].[2E60544D37534C0B89E765FE29BC0B43] And now it seems to be: [organization].[organization].[0].[19404EAD144C49A0AF37D54377CF452D].[2E60544D37534C0B89E765FE29BC0B43] |
||
| Revision | 2018-08-17 08:27 by dmiguelez | ||
| Description | Data is not shown in report. An error is raised, making the report unusable. | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |