Cube View Export using TI process

[Meg]

Hi,

How to export .csv file by using the Cube view at consolidated level in TI process?i am able to export through tI process using ASCIIOUTPUT but I need at consolidated level.

[jim wood]

You need to include consolidations in your view and have them enabled in the export properties. This covered extensively in the developer guide. I'd also recommend going through the functions in the reference guide.

[Meg]

Hi Jim,

Thanks for your suggestion but I have only one consolidation & have 158 GL Codes as leaf level elements.as these elements are mapped to different Salary components of Employees like Bonus,Gross Pay,Net Pay,expense etc.i need the data consolidation of each leaf level elements,how do I do it?

Only One Consolidation

Consolidation.png (3.54 KiB) Viewed 7115 times

[David Usherwood]

If you explained what 'data consolidations' meant, it would help.
If you need to group your GL codes into totals, you need to add parent elements to the dimension and chart the children.
If you just need to export them with different names eg 410100 = Gross Pay, create, populate and use an alias.
It's all in the manuals.

[Meg]

Hi David,

Here are the attached screen shots, currently I am getting the export at leaf level.

leaf level.png (45.7 KiB) Viewed 7097 times

But need the export as below, how to do this ? as all the Dimension in the cube has only one consolidation as total.

Consolidated level.PNG (71.65 KiB) Viewed 7097 times

[qml]

But need the export as below, how to do this ? as all the Dimension in the cube has only one consolidation as total.

You need to think which dimensions you are not showing/splitting in your extract. For any such dimension you will need to have a total consolidation in the dimension and use that in the source view (also remember to set the source view not to skip consolidations, which views do by default). That way you will achieve data aggregated to the granularity of the extract rather than the granularity of the cube (which looks to be greater). If it's something else that you're after then you have not made it very clear, despite the pictures.

[lotsaram]

You do aggregations in TM1 via dimension consolidations, period.

If you don't have any other consolidations in Account other than total then you need to create them. Then process these.

[Meg]

thanks all.I was able to export at the consolidated level but the posting key against the value is matching.
Posting key logic is mentioned below,

IF(V17=1);
IF(Value>0);
vPosting='50';
ELSE;
vPosting='40';
Endif;
Else;
IF(Value>0);
vPosting='40';
ELSE;
vPosting='50';
Endif;
ENDIF;

attached picture of the export.

posting key not matching.png (24.45 KiB) Viewed 6957 times

[Meg]

attached the picture of the variables.

defined Variables.png (24.23 KiB) Viewed 6956 times

[Meg]

data tab.png (21.55 KiB) Viewed 6955 times