Hyperion Essbase (MOSC)

MOSC Banner

Unable to load data through Essbase Studio

edited Sep 13, 2012 7:47AM in Hyperion Essbase (MOSC) 3 commentsAnswered
 We are loading metadata and data from tables in Oracle DB to Essbase cube through Studio.  We are following the below process.
Fact Table
All dimensions foreign keys and "Actual" data present in here. Actual is one of our scenario. This fact table has one column which is "varchar" and the rest are "numbers". Actual data column is a "number".

Dimension Table
The dimension table contains all the dimensions used like Account, Period, Dealer, Entity, Scenario.

What should be the "measure" dimension in this case i.e., "Scenario"? 

If we make Scenario as a Measure dimension, how about the Accounts dimension which will not have any of the properties which we get from tagging it  as Accounts Type dimension.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center