Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PBCS Aggregation and Calculation

user12087508Nov 7 2017 — edited Nov 8 2017

We have a PBCS cube with around 24GB of data. Our biggest dimension is project dimension that is

-Project

    Project_A( Base dimension 15,787 total members all levels)

    Project B (887 all levels with level 0 shared)

   Project C (7839 all levels with level 0 shared)

   Project C (16344 all levels with level 0 shared)

We keep getting the answer that because our project dimension is so big our aggregations and calculations will take a really long time. In my mind, as most of the dimensions are shared it should not be terrible long. It is a multi currency cube with below mentioned structure:

- Account (dense) 1819 members

- Period (dense) 133

- Level(DENSE) 44

-Site(SPARSE) 1102

-Department(SPARSE) 1224

-Project(SPARSE) 40857

-Years(SPARSE) 4

-Version(SPARSE) 10

-Scenario(SPARSE) 25

-Currency(SPARSE) 50

Is this a really big cube? I have seen much bigger on-premise planning cubes however new to pbcs so wanted to know the opinions.

Thank you

Comments

JeffJon
Have you tried updating the configuration setting for the amount of time that the message is displayed?
LarryR
James, I don't know if thiere is a way to promote your Info Bar message, but given that it may not be possible, would a pop-up window work better in this situation?
783124
Yes this is a good solution, or at least it would be if the message window were left on top, instead of the modal popup and the main window taking centre-stage again a split second later! Is there a way to keep this message window on top?

Another possible solution - do you know if it would be possible to add the message to the "LoadOptMethodVal" Option of the adapter, by passing in the message string? It would be great if the message could feature in the Target System Load modal popup. I suspect not, but it would be ideal, since this would then give the user the option of whether to proceed with the data load or not. I tried modifying the Description field, but this does not appear to feature in the modal popup.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2017
Added on Nov 7 2017
#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting
2 comments
1,068 views