Define sort order of dimensions in a DATAEXPORT? And why is one dimension not delivered in a column?
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).