ODBO cube creation and data population

[Steve Joffe]

Hi All,

I am trying to create a Tm1 cube and populate it via odbo from an analysis services cube.
I have all the set up correct and the cube is created in Tm1 however no data pulls through.
Is it possible to create the cube and populate it in 1 process and if not what is the mdx syntax to populate only n level elements?

Thanks
Steve

[rkaif]

Steve, yes it is possible to pull the data and create the cube in the same TI process

To create the cube you need to go to Maps->Cube tab and select the 'Create Cube' option, then on the Dimension tab you have to slect and map the the dimension which you want to include in the new cube.

In the Advance->Data tab, make sure you are putting the data at the correct level/intersection.

[Steve Joffe]

I have set the process to create the cube and populate the data, it does create all the relevant sub processes and creates the cube correctly, however it does not populate any data. I do have data in the AS cube as well as a Cellputn under the advanced tab, but still no data in my Tm1 cube.

[Marcus Scherer]

to check if data are in the cube did you export your TM1 cube data into a flat file and see if something is written into the file?

[Steve Joffe]

Hi Marcus,

I have exported the cube and no data exists.
I have logged a call with IBM, so I'll see what comes of that and post the results here.

[Alan Kirk]

I have set the process to create the cube and populate the data, it does create all the relevant sub processes and creates the cube correctly, however it does not populate any data. I do have data in the AS cube as well as a Cellputn under the advanced tab, but still no data in my Tm1 cube.

It might be an idea to post a copy of the the .pro file here. Personally I wouldn't trust TI-generated code as far as I can throw it but it's difficult to say what might be going wrong without being able to see the code itself.

[Steve Joffe]

Hi Alan,

Apologies for the delay, I was on leave for a week, Happy new year to you.
Below is a copy of the entire .pro file.
I have a look through the generated code and it appears to be correct.
Let me know your thoughts.

Steve

601,100
562,"ODBOCUBE"
586,"\SQL2008"
585,"\SQL2008"
564,
565,"rU\7iI\j[a_jv>0mg9a>0U7nPPnumh^kQn4Z83wFRLyeyc2v1<cFoba5@?HPA_x`TWfFwNef>Vz[bJp_;PNu6n91DdmlQ1:=BN0BMtsq4Fz?BFfeta5@yF\TtI_@g1\4PV2s<K2TJS?jm8k8][GRhmuN6VfGPkU18oTUl]f9cLdkS^tl3=:yq<NSwNOT\ofk1nY5:DWv"
559,1
593,"MSOLAP"
594,
595,"CompanyX"
597,
598,
596,
800,
801,
566,67
WITH
SET [Account_Acc Level Type Set] AS
'{ FILTER( { [Account].[Acc Level Type].MEMBERS }, ISLEAF( [Account].[Acc Level Type].CURRENTMEMBER ) ) }'
SET [Account_Acc Type Set] AS
'{ FILTER( { [Account].[Acc Type].MEMBERS }, ISLEAF( [Account].[Acc Type].CURRENTMEMBER ) ) }'
SET [Account_Account Set] AS
'{ FILTER( { [Account].[Account].MEMBERS }, ISLEAF( [Account].[Account].CURRENTMEMBER ) ) }'
SET [Account_Enabled Set] AS
'{ FILTER( { [Account].[Enabled].MEMBERS }, ISLEAF( [Account].[Enabled].CURRENTMEMBER ) ) }'
SET [Country_Country Set] AS
'{ FILTER( { [Country].[Country].MEMBERS }, ISLEAF( [Country].[Country].CURRENTMEMBER ) ) }'
SET [Currency_Currency Set] AS
'{ FILTER( { [Currency].[Currency].MEMBERS }, ISLEAF( [Currency].[Currency].CURRENTMEMBER ) ) }'
SET [Entity_Brand Set] AS
'{ FILTER( { [Entity].[Brand].MEMBERS }, ISLEAF( [Entity].[Brand].CURRENTMEMBER ) ) }'
SET [Entity_Business Unit Set] AS
'{ FILTER( { [Entity].[Business Unit].MEMBERS }, ISLEAF( [Entity].[Business Unit].CURRENTMEMBER ) ) }'
SET [Entity_Comparable Set] AS
'{ FILTER( { [Entity].[Comparable].MEMBERS }, ISLEAF( [Entity].[Comparable].CURRENTMEMBER ) ) }'
SET [Entity_Cost Centre Set] AS
'{ FILTER( { [Entity].[Cost Centre].MEMBERS }, ISLEAF( [Entity].[Cost Centre].CURRENTMEMBER ) ) }'
SET [Entity_Cost Centre Type Set] AS
'{ FILTER( { [Entity].[Cost Centre Type].MEMBERS }, ISLEAF( [Entity].[Cost Centre Type].CURRENTMEMBER ) ) }'
SET [Entity_Enabled Set] AS
'{ FILTER( { [Entity].[Enabled].MEMBERS }, ISLEAF( [Entity].[Enabled].CURRENTMEMBER ) ) }'
SET [Entity_Legal Entity Set] AS
'{ FILTER( { [Entity].[Legal Entity].MEMBERS }, ISLEAF( [Entity].[Legal Entity].CURRENTMEMBER ) ) }'
SET [Entity_Location Type Set] AS
'{ FILTER( { [Entity].[Location Type].MEMBERS }, ISLEAF( [Entity].[Location Type].CURRENTMEMBER ) ) }'
SET [Entity_Management Division Set] AS
'{ FILTER( { [Entity].[Management Division].MEMBERS }, ISLEAF( [Entity].[Management Division].CURRENTMEMBER ) ) }'
SET [Entity_Management Hierarchy Set] AS
'{ FILTER( { [Entity].[Management Hierarchy].MEMBERS }, ISLEAF( [Entity].[Management Hierarchy].CURRENTMEMBER ) ) }'
SET [Entity_Management Region Set] AS
'{ FILTER( { [Entity].[Management Region].MEMBERS }, ISLEAF( [Entity].[Management Region].CURRENTMEMBER ) ) }'
SET [Entity_Management Responsibility Area Set] AS
'{ FILTER( { [Entity].[Management Responsibility Area].MEMBERS }, ISLEAF( [Entity].[Management Responsibility Area].CURRENTMEMBER ) ) }'
SET [Entity_Planned Revamp End Date Set] AS
'{ FILTER( { [Entity].[Planned Revamp End Date].MEMBERS }, ISLEAF( [Entity].[Planned Revamp End Date].CURRENTMEMBER ) ) }'
SET [Entity_Planned Revamp Start Date Set] AS
'{ FILTER( { [Entity].[Planned Revamp Start Date].MEMBERS }, ISLEAF( [Entity].[Planned Revamp Start Date].CURRENTMEMBER ) ) }'
SET [Entity_Responsibility Area Set] AS
'{ FILTER( { [Entity].[Responsibility Area].MEMBERS }, ISLEAF( [Entity].[Responsibility Area].CURRENTMEMBER ) ) }'
SET [Entity_Store Close Date Set] AS
'{ FILTER( { [Entity].[Store Close Date].MEMBERS }, ISLEAF( [Entity].[Store Close Date].CURRENTMEMBER ) ) }'
SET [Entity_Store Open Date Set] AS
'{ FILTER( { [Entity].[Store Open Date].MEMBERS }, ISLEAF( [Entity].[Store Open Date].CURRENTMEMBER ) ) }'
SET [Entity_Trading Space Set] AS
'{ FILTER( { [Entity].[Trading Space].MEMBERS }, ISLEAF( [Entity].[Trading Space].CURRENTMEMBER ) ) }'
SET [Measures Set] AS
'{ FILTER( { [Measures].MEMBERS }, ISLEAF( [Measures].CURRENTMEMBER ) ) }'
SET [Scenario_Scenario Set] AS
'{ FILTER( { [Scenario].[Scenario].MEMBERS }, ISLEAF( [Scenario].[Scenario].CURRENTMEMBER ) ) }'
SET [Time_Financial Calendar Set] AS
'{ FILTER( { [Time].[Financial Calendar].MEMBERS }, ISLEAF( [Time].[Financial Calendar].CURRENTMEMBER ) ) }'
SET [Time_Half Year Set] AS
'{ FILTER( { [Time].[Half Year].MEMBERS }, ISLEAF( [Time].[Half Year].CURRENTMEMBER ) ) }'
SET [Time_Month Set] AS
'{ FILTER( { [Time].[Month].MEMBERS }, ISLEAF( [Time].[Month].CURRENTMEMBER ) ) }'
SET [Time_Year Set] AS
'{ FILTER( { [Time].[Year].MEMBERS }, ISLEAF( [Time].[Year].CURRENTMEMBER ) ) }'
SELECT NONEMPTYCROSSJOIN (
[Account_Acc Level Type Set] , [Account_Acc Type Set] , [Account_Account Set] , [Account_Enabled Set] , [Country_Country Set] , [Currency_Currency Set] , [Entity_Brand Set] , [Entity_Business Unit Set] , [Entity_Comparable Set]
, [Entity_Cost Centre Set] , [Entity_Cost Centre Type Set] , [Entity_Enabled Set] , [Entity_Legal Entity Set] , [Entity_Location Type Set] , [Entity_Management Division Set] , [Entity_Management Hierarchy Set] , [Entity_Management Region Set]
, [Entity_Management Responsibility Area Set] , [Entity_Planned Revamp End Date Set] , [Entity_Planned Revamp Start Date Set] , [Entity_Responsibility Area Set] , [Entity_Store Close Date Set] , [Entity_Store Open Date Set]
, [Entity_Trading Space Set] , [Measures Set] , [Scenario_Scenario Set] , [Time_Financial Calendar Set] , [Time_Half Year Set] , [Time_Month Set] , [Time_Year Set]
) ON COLUMNS FROM [CompanyX Management Financial]
567,","
588,"."
589,
568,""""
570,
571,
569,0
592,0
599,1000
560,0
561,0
590,0
637,0
577,33
Account
Account2
Account23
Account234
Country
Currency
Entity
Entity2
Entity23
Entity234
Entity2345
Entity23456
Entity234567
Entity2345678
Entity23456789
Entity2345678910
Entity234567891011
Entity23456789101112
Entity2345678910111213
Entity234567891011121314
Entity23456789101112131415
Entity2345678910111213141516
Entity234567891011121314151617
Entity23456789101112131415161718
Measures
Scenario
V1
V12
V123
V1234
NVALUE
SVALUE
VALUE_IS_STRING
578,33
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
1
2
1
579,33
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
0
0
0
580,33
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
581,33
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
582,30
ODBOCubeODBODimName=[Account].[Acc Level Type]ODBOCubeODBODimTIName=Create Cube_Account_Acc Level TypeODBOCubeTM1DimName=Account_Acc Level TypeODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Account].[Acc Type]ODBOCubeODBODimTIName=Create Cube_Account_Acc TypeODBOCubeTM1DimName=Account_Acc TypeODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Account].[Account]ODBOCubeODBODimTIName=Create Cube_Account_AccountODBOCubeTM1DimName=Account_AccountODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Account].[Enabled]ODBOCubeODBODimTIName=Create Cube_Account_EnabledODBOCubeTM1DimName=Account_EnabledODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Country].[Country]ODBOCubeODBODimTIName=Create Cube_Country_CountryODBOCubeTM1DimName=Country_CountryODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Currency].[Currency]ODBOCubeODBODimTIName=Create Cube_Currency_CurrencyODBOCubeTM1DimName=Currency_CurrencyODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Brand]ODBOCubeODBODimTIName=Create Cube_Entity_BrandODBOCubeTM1DimName=Entity_BrandODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Business Unit]ODBOCubeODBODimTIName=Create Cube_Entity_Business UnitODBOCubeTM1DimName=Entity_Business UnitODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Comparable]ODBOCubeODBODimTIName=Create Cube_Entity_ComparableODBOCubeTM1DimName=Entity_ComparableODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Cost Centre]ODBOCubeODBODimTIName=Create Cube_Entity_Cost CentreODBOCubeTM1DimName=Entity_Cost CentreODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Cost Centre Type]ODBOCubeODBODimTIName=Create Cube_Entity_Cost Centre TypeODBOCubeTM1DimName=Entity_Cost Centre TypeODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Enabled]ODBOCubeODBODimTIName=Create Cube_Entity_EnabledODBOCubeTM1DimName=Entity_EnabledODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Legal Entity]ODBOCubeODBODimTIName=Create Cube_Entity_Legal EntityODBOCubeTM1DimName=Entity_Legal EntityODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Location Type]ODBOCubeODBODimTIName=Create Cube_Entity_Location TypeODBOCubeTM1DimName=Entity_Location TypeODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Management Division]ODBOCubeODBODimTIName=Create Cube_Entity_Management DivisionODBOCubeTM1DimName=Entity_Management DivisionODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Management Hierarchy]ODBOCubeODBODimTIName=Create Cube_Entity_Management HierarchyODBOCubeTM1DimName=Entity_Management HierarchyODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Management Region]ODBOCubeODBODimTIName=Create Cube_Entity_Management RegionODBOCubeTM1DimName=Entity_Management RegionODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Management Responsibility Area]ODBOCubeODBODimTIName=Create Cube_Entity_Management Responsibility AreaODBOCubeTM1DimName=Entity_Management Responsibility AreaODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Planned Revamp End Date]ODBOCubeODBODimTIName=Create Cube_Entity_Planned Revamp End DateODBOCubeTM1DimName=Entity_Planned Revamp End DateODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Planned Revamp Start Date]ODBOCubeODBODimTIName=Create Cube_Entity_Planned Revamp Start DateODBOCubeTM1DimName=Entity_Planned Revamp Start DateODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Responsibility Area]ODBOCubeODBODimTIName=Create Cube_Entity_Responsibility AreaODBOCubeTM1DimName=Entity_Responsibility AreaODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Store Close Date]ODBOCubeODBODimTIName=Create Cube_Entity_Store Close DateODBOCubeTM1DimName=Entity_Store Close DateODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Store Open Date]ODBOCubeODBODimTIName=Create Cube_Entity_Store Open DateODBOCubeTM1DimName=Entity_Store Open DateODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Entity].[Trading Space]ODBOCubeODBODimTIName=Create Cube_Entity_Trading SpaceODBOCubeTM1DimName=Entity_Trading SpaceODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Measures]ODBOCubeODBODimTIName=Create Cube_MeasuresODBOCubeTM1DimName=MeasuresODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Scenario].[Scenario]ODBOCubeODBODimTIName=Create Cube_Scenario_ScenarioODBOCubeTM1DimName=Scenario_ScenarioODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Time].[Financial Calendar]ODBOCubeODBODimTIName=Create Cube_Time_Financial CalendarODBOCubeTM1DimName=Time_Financial CalendarODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Time].[Half Year]ODBOCubeODBODimTIName=Create Cube_Time_Half YearODBOCubeTM1DimName=Time_Half YearODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Time].[Month]ODBOCubeODBODimTIName=Create Cube_Time_MonthODBOCubeTM1DimName=Time_MonthODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
ODBOCubeODBODimName=[Time].[Year]ODBOCubeODBODimTIName=Create Cube_Time_YearODBOCubeTM1DimName=Time_YearODBOCubeTM1DimAction=1ODBOCubeODBODimFilterApplied=0
572,134

#****Begin: Generated Statements***
IF ( CUBEEXISTS('CompanyX Management Financial') <> 0 );
CUBEDESTROY('CompanyX Management Financial');
ENDIF;
ret_code=EXECUTEPROCESS('Create Cube_Account_Acc Level Type');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Account_Acc Type');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Account_Account');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Account_Enabled');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Country_Country');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Currency_Currency');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Brand');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Business Unit');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Comparable');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Cost Centre');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Cost Centre Type');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Enabled');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Legal Entity');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Location Type');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Management Division');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Management Hierarchy');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Management Region');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Management Responsibility Area');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Planned Revamp End Date');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Planned Revamp Start Date');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Responsibility Area');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Store Close Date');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Store Open Date');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Entity_Trading Space');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Measures');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Scenario_Scenario');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Time_Financial Calendar');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Time_Half Year');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Time_Month');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
ret_code=EXECUTEPROCESS('Create Cube_Time_Year');
if (ret_code = ProcessExitSeriousError() );
ProcessError();
endif;
CUBECREATE('CompanyX Management Financial','Account_Acc Level Type','Account_Acc Type','Account_Account','Account_Enabled','Country_Country','Currency_Cu
rrency','Entity_Brand','Entity_Business Unit','Entity_Comparable','Entity_Cost Centre','Entity_Cost Centre Type','Entity_Enabled','Entity_Legal Entity
','Entity_Location Type','Entity_Management Division','Entity_Management Hierarchy','Entity_Management Region','Entity_Management Responsibility Area'
,'Entity_Planned Revamp End Date','Entity_Planned Revamp Start Date','Entity_Responsibility Area','Entity_Store Close Date','Entity_Store Open Date','
Entity_Trading Space','Measures','Scenario_Scenario','Time_Financial Calendar','Time_Half Year','Time_Month','Time_Year');
OldCubeLogChanges = CUBEGETLOGCHANGES('CompanyX Management Financial');
CUBESETLOGCHANGES('CompanyX Management Financial', 0);
#****End: Generated Statements****

573,3

#****Begin: Generated Statements***
#****End: Generated Statements****
574,11

#****Begin: Generated Statements***
IF (VALUE_IS_STRING=1, CELLPUTS(SVALUE,'CompanyX Management Financial',Account,Account2,Account23,Account234,Country,Currency,Entity,Entity2,Entity23,Ent
ity234,Entity2345,Entity23456,Entity234567,Entity2345678,Entity23456789,Entity2345678910,Entity234567891011,Entity23456789101112,Entity234567891011121
3,Entity234567891011121314,Entity23456789101112131415,Entity2345678910111213141516,Entity234567891011121314151617,Entity23456789101112131415161718,Mea
sures,Scenario,V1,V12,V123,V1234), CELLPUTN(NVALUE, 'CompanyX Management Financial', Account,Account2,Account23,Account234,Country,Currency,Entity,Entity
2,Entity23,Entity234,Entity2345,Entity23456,Entity234567,Entity2345678,Entity23456789,Entity2345678910,Entity234567891011,Entity23456789101112,Entity2
345678910111213,Entity234567891011121314,Entity23456789101112131415,Entity2345678910111213141516,Entity234567891011121314151617,Entity2345678910111213
1415161718,Measures,Scenario,V1,V12,V123,V1234));
#****End: Generated Statements****

575,5

#****Begin: Generated Statements***
CUBESETLOGCHANGES('CompanyX Management Financial', OldCubeLogChanges);
#****End: Generated Statements****

576,ODBOCubeName=CompanyX Management FinancialTM1CubeName=CompanyX Management FinancialTM1CubeAction=1TM1CubeType=0TM1DataAction=0TM1ViewZeroOut=0TM1CubeLoggingEnabled=0
638,1
804,0
1217,0
900,
901,
902,
903,
906,
907,
908,
904,0
905,0
909,0
911,
912,
913,
914,
915,
916,
917,1
918,1
919,0
920,50000
921,""
922,""
923,0
924,""
925,""
926,""
927,""