Hyperion Essbase (MOSC)

MOSC Banner

Define sort order of dimensions in a DATAEXPORT? And why is one dimension not delivered in a column?

edited Dec 8, 2013 11:44PM in Hyperion Essbase (MOSC) 6 commentsAnswered
Hi all,

I have a problem with theDATAEXPORT function. A Calc script exports data into an SQL table.

The cube looks like this:

Time (Dense)

Time_Dyn (Dense)

Scale (Dense)

View (Dense)

Datatype (Sparse)

BusinessUnit (Sparse)

Positions (Accounts, Sparse)

when i do an export with     DATAEXPORT "DSN" "vdcsrdw" "dbo.tFact_Forecast_ActualPeriods_Export" "essb_system" "Password"

Essbase creates the following INSERT STATEMENT:

INSERT INTO dbo.tFact_Forecast_ActualPeriods_Export2 VALUES ('Export_Forecast','BU_8','110220','Current Month','Scale_1','M01_2012',64332.630000000005000,64332.630000000005000,NULL)

Every Dimension can be found in this statement except the View dimension (which contains 3 lelvel zero members (Group View, Local View, Segment View).

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