TM1 Forum

Thank you for your help.

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 (cCub...

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 ViewExtractSki...

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

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

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 ASCIIO...

ok thank you

I tried joining with pipes earlier in the MDX with attributes but it didn't work.
Anyways, Expand works perfect . Thank you.

Can't thank you enough I had spent a lot of time in this and needed this urgently. Thank you so much. It works perfect. Just for my knowledge sake I have 1 more question if you have time to answer. Why we didn't need to use Expand in the below MDX since here also we are using a parameter for Element...

Hello, I am trying for create an MDX in a TI process but it gives me the error "cAttrValueStart" : object not found expression. Basically the MDX tries to filter the values in the dimension 'Time' base on a numeric attribute value. Not sure how do I put 'cAttrValueStart' in my MDX so that ...

Thank you Wim Gielis and gtonkin for your reply.
IF(ISERROR....) worked for me and I calculated the End date of the month by the old way in Excel.

Thanks.

Hi all, One of the Date columns in my Active form displays #NAME? error when opened in TM1Web while it works fine in Perspectives. Here is the formula which drives the column =IFERROR(EOMONTH(B29&"/1/"&C29,0),"") I read that IFERROR formula shows error in TM1Web so I trie...