Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #39148 All Revisions ] 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]]


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker