TM1 Forum

Hello,

I created a TI process where data needs to be uploaded into a cube from a csv file.
In the Prolog tab there is source view created which I have checked in the cube as well but somehow the data was not getting loaded into the cube even though the process ran successfully.

I checked with ASCIIOUTPUT that Metadata and Data tab are not getting processed while Prolog tab does and the target view is created.

I have checked that the view has no consolidations and this statement is there.
ViewExtractSkipCalcsSet (cCubeName, cViewName,0);

Attaching the prolog.

Any help is appreciated. Please.

Thanks.

cognos4321 wrote: ↑Thu Dec 17, 2020 6:31 pm I created a TI process where data needs to be uploaded into a cube from a csv file.
In the Prolog tab there is source view created

I'm not sure to understand because you said you want to load data in a cube from a csv file but you are using the view created in the prolog as data source ?
What is your data source...CSV or Cube View ?

The data source is a csv file but I created a target view for the target cube.

I got your point. Thank you.
I messed between my export and import process.

Sorry to bother you again.

I fixed the process and it runs successfully.
The only issue is that the cells in the target cube are rule driven which is not letting the data get copied.
I checked the data coming through using ACIIOUTPUT and have used this in the prolog:

# Dont Skip Rules
ViewExtractSkipRuleValuesSet (cCubeName, cViewName, 0);

I have already created a duplicate of the target cube and removed the rule file. The data gets copied correctly in that cube.
What else can I do so that data gets copied over the rule driven cells.

Thank you.

cognos4321 wrote: ↑Thu Dec 17, 2020 9:14 pm What else can I do so that data gets copied over the rule driven

You can't load data in a cube if there is rules.

Thanks much for the reply.

So, this function can be used only to extract view without skipping rule driven cells.
This does not apply to when we are loading data into rule driven cells.
And there is no way we can load data on top of rule driven cells. Am I correct?

ViewExtractSkipRuleValuesSet (cCubeName, cViewName, 0);

Thank you.

cognos4321 wrote: ↑Thu Dec 17, 2020 10:03 pm And there is no way we can load data on top of rule driven cells.

Correct.

You can use the CellIsUpdateable function to determines whether a cube cell can be written to.

Thank you for your help.