TM1 Ventilation Process successfull but no data transfered

[Pierre06]

Hi,

I have a 3 cubes: 1 for input data, 1 for ventilation percentage and 1 for output data.
My cubes are made of the following dimensions:
1. Input data (in this order):
4_Product_P&L_Category
4_Version
2_Sites
3_Month_Year
2_Budget_Lines
2_Cost_Centers
1_Category

2. Ventilation (in this order):
4_Version
2_Budget_Lines (each element is allocated to the elements of the 2_Product_List dimension by percentage)
3_Month_Year
2_Product_List
1_Ventilation

3. Output data (in this order):
4_Product_P&L_Category
4_Version
3_Month_Year
2_P&L_Structure
2_Product_List
1_Category

In my process, as default view I have:
V1 = 1_Category
V2 = 4_Product_P&L_Category
P1 = 4_Version
V6 = 2_Budget_Lines
V7 = 3_Month_Year

Then I wrote the ventillation process in 3 steps:
vValue = CellGetN('INPUT_CUBE', V2, P1, 'TOTAL ALL SITES', V7, V6, 'TOTAL', 'Value');
vVentil1 = CellGetN('VENTILLATION', P1, V6, V7, 'Product_A', 'Percent');
vSend1 = vValue * vVentil1;
IF(CellIsUpdateable('OUTPUT_Cube', V2, P1, V7, 'Costs', 'Product_A', V1)=1);
CellPutN(vSend1, 'PRODUCT_P&L_OUTPUT', V2, P1, V7, 'Costs', 'Product_A', V1);
ENDIF;

The process runs successfully but no data are transferring.
Can anybody help me on this issue ? What is wrong in the coding ? I dream of this code at night without finding where the mistake is

Thanks for your help.

[Wim Gielis]

One of the things to consider:

Turn off this IF test:

Code: Select all

IF(CellIsUpdateable('OUTPUT_Cube', V2, P1, V7, 'Costs', 'Product_A', V1)=1);

and see what errors you get.
Do you try to write to a consolidated level? Try to write to a rules-calculated cell?

[Pierre06]

Hi Wim,

thanks for your reply.

I removed the IF formula. As you stated I want to put data on a leaf element without any rules applying on it.
CellPutN(vSend1, 'OUTPUT_Cube', V2, P1, V7, 'Costs', 'Product_A', V1);
The process runs successfully but still no data are transferred.

In order to know at what step the process is not functionning I tried to disable step 1 and 2 and simply send 1000 euros in OUTPUT_Cube by writting:
CellPutN(1000, 'OUTPUT_Cube', V2, P1, V7, 'Costs', 'Product_A', V1);
The process runs successfully but no data transferred. I then tried to put the 1000 euros on single elements (leafs with no rule attached), but I got the same result
CellPutN(1000, 'OUTPUT_Cube', 'Euro', 'Actuals', '012013', 'Costs', 'Product_A', 'Value');
It is as if the data are not stored in the cube.

Any idea ?
Thanks.

[Wim Gielis]

Are you sure that you enter the Metadata and Data tab? That is, do you have data in the data source (which is probably a view)?
Make sure that you enter the Data tab by using AsciiOutput at the top of that tab.

[Pierre06]

In fact I have nothing in Metadata. All the infos I copied in my post are in the Data tab.
I did not fille din the Metadata tab as I do not proceed to any change in the structure, I only send data.
Do I need to copy anything in Metadata ?

[michael_gcph]

He probably meant whether is your TI process really reaches your MetaData/Data tab. A simple AsciiOutput can help you. And while you're at it, do include the contents also of your variables (v*) that you've used in your CellPutN() so that you will be able to see what's coming in as data.

I.e. On top of your Data tab, as the first line of code, try to have a code such as:
AsciiOutput('c:\my_ti_data.txt', V2, P1, V7, numbertostring(vSend1));

If you happen don't see that my_ti_data.txt file, then something else is wrong. Better to check your ViewSkip* flags in your Prolog. But if you do see that, then examine your data/elements and make sure that you don't have any C-Elements or Rule-Calculated measure.

[Pierre06]

Thanks Michael.
I put on top of the Data tab the ASCII code you wrote, process runs successfully but I couldn't find the file on my C: drive.

To answer your last note I have no ViewSkip in my prolog. I have a ViewZeroOut to erase the data before importing. I tested this instruction which works fine.

[Wim Gielis]

Indeed, I meant what Michael kindly wrote down.

As he also pointed out (at least implicitly), TM1 skips by default all cells that are consolidated, or zero valued, or rules-calculated.
Hence, your data source view could contain cells, yet you do not enter the Data tab as the view probably does not contain any cell that is:

- non-zero
- lowest level in all dimensions of the cube
- a white cell (not rules-calculated)

So, check your data source / view.

[Pierre06]

In my source view I have, indeed, consolidated levels as some dimensions are not replicated in the OUTPUT_Cube.
vValue = CellGetN('INPUT_CUBE', V2, P1, 'TOTAL ALL SITES', V7, V6, 'TOTAL', 'Value');

I therefore need to get the consolidated level, am I wrong in my reasoning ?
If yes, what should I use instead ?

[Pierre06]

but by the way, even the test instruction on the OUTPUT_Cube is not working: I tried to put 1000 euros on single elements (leafs with no rule attached), process successfull but no data transferred

CellPutN(1000, 'OUTPUT_Cube', 'Euro', 'Actuals', '012013', 'Costs', 'Product_A', 'Value');

Could it be because the dimension 1_Category which contains only 1 leaf element 'Value' is used in other cubes ?
This instruction is basic but doesn't work

[tomok]

You've been given the answer to this riddle. No data is being written to the cube because your view is empty!!!!!! When a data source is empty you won't get any error messages other than successful completion of the process. Your view is empty because you have consolidated nodes in the view and you have configured the view to skip consolidated values. As long as at least one of your dimension element choices is a consolidated node, in your case 'TOTAL ALL SITES', then setting the view flag "Skip Consolidated Values" to true WILL RESULT IN ALL VALUES BEING SUPPRESSED. Your data source will be empty and nothing will happen when you run the process except to get a message saying it was successful. Turn off the "Skip Consolidated Values" flag and run it again.

[Pierre06]

Thanks Tomok.
I checked in the Process but I couldn't find any place where to turn off the Skip Consolidated Values. Can you, please tell me where or how doing it ?

Nevertheless, I am still a bit surprised with the test instruction that doesn't work (all leaf elements with no rules attached)
CellPutN(1000, 'OUTPUT_Cube', 'Euro', 'Actuals', '012013', 'Costs', 'Product_A', 'Value');

[tomok]

Thanks Tomok.
I checked in the Process but I couldn't find any place where to turn off the Skip Consolidated Values. Can you, please tell me where or how doing it ?

It depends. Are you building the view in the TI process or are you using a view that already exists? if you are building the view as part of the TI then read up on the function ViewExtractSkipCalcsSet. If it is an already existing view you can change the options by right-clicking on the view and choose Export as text Data, changing the flag and then saving.

Nevertheless, I am still a bit surprised with the test instruction that doesn't work (all leaf elements with no rules attached)

Why would you expect it to work? If no records exist in the view then the Metadata and Data tabs are never executed. Put your test CellPutN code in the Prolog and try it again.

[Pierre06]

I finally found the "Skip Consolidated Values" option and un-ticked it.
I had to save a view and re-order the variables in the coding.

The process runs successfully but this time I can see there is a real calculation happenning or at least the different steps are going through.
But again no data transferred ...

I put the ASCII code in the Data tab, just before the instruction to send data, to see what data should be transferred, but there is no file creating.
AsciiOutput('c:\my_ti_data.txt', V1, P1, V4, 'vSend1');

[tomok]

I put the ASCII code in the Data tab, just before the instruction to send data, to see what data should be transferred, but there is no file creating.

Then this would indicate your data source is still empty. What about the other option, "ViewExtractSkipRuleValuesSet", is this applicable to your view?

[Pierre06]

Tomok,

the "ViewExtractSkipRuleValuesSet" option you mentionned is not applicable to the source view.

Coming back to previous post I made, I was expecting the instruction to work just to see if the OUTPUT_Cube was correctly storing the data I wanted to send. To do this I disabled the toher calculation steps (i.e. retrieve the info in the source cube and retrieve the info of the ventilation cube). I simply wanted to send 1000 in the OUTPUT_Cube on leaf elements.
As it did not work I was wondering if the OUTPUT_Cube was correctly storing the info and if the error couldn't come from here instead of the source view ...
CellPutN(1000, 'OUTPUT_Cube', 'Euro', 'Actuals', '012013', 'Costs', 'Product_A', 'Value');

[Wim Gielis]

Hello

If you add up all comments made in this topic, you have ALL clues to solve this one.
Make sure your source view is not 'empty' (manage rules and/or consolidated cells and/or zeroes). Either manually on a saved view, either through code.

Put a very basic CellPutN code in the Prolog and a slightly different one in the Data tab. See what gets executed.

Use AsciiOutput extensively to debug and see what is going on.

Wim

[Pierre06]

Hello Wim,

I am looking closely at it and I am getting more and more down.
1. I put an ASCII instruction after each step as follows:
vValue = CellGetN('INPUT_Cube', V1, P1, 'TOTAL ALL SITES', V4, V5, 'TOTAL', V7);
AsciiOutput('c:\my_ti_data_source.txt', V1, P1, V5, V4, 'vValue');

vVentil1 = CellGetN('VENTILATION', P1, V5, V4, 'Selling Platform', 'Percent');
AsciiOutput('c:\my_ti_data_ventil.txt', P1, V5, V4, 'vVentil1');

vSend1 = vValue * vVentil1;
AsciiOutput('c:\my_ti_data.txt', V1, P1, V4, 'vSend1');
CellPutN(vSend1, 'OUTPUT_Cube', V1, P1, V4, 'ACC PCC Products', 'Selling Platform', V7);

For each of them I did not get any file created

2. I checked the process does not exclude the consolidated element to allow to retrieve 'TOTAL ALL SITES' and 'TOTAL' elements of the source view.

3. The only good news is that I tested the basic CellPutN in both prolog and Data tab and it worked.

[Wim Gielis]

Hello Pierre

You are clearly missing some real basic concepts in TI processes, you should familiarize yourself with these concepts as soon as possible.
For example, through a formal training.

For example, is it your wish to have the numeric value vValue in the ascii output (text file)? Then that is not going to work like that, you need the function NumberToString (or similar)

I am not prepared to yet again copy/echo what has been said earlier in this topic. You still do not understand the concept of different types of cells within the source data view.

[Pierre06]

Hi,

for those who are interested, the solution has been found.
The ASCII files were generated, I was checking on my personal C: drive as teh command was AsciiOutput('c:\my_ti_data.txt', V1, P1, V4, 'vSend1'); but I should have looked directly on the C: drive of the server.

From a command perspective, as there was a n to 1 relation between the element V5 and 'Selling Platform' I should have used the CellIncrementN function instead of the CellPutN. The data were replacing each other and the last one was 0.