TM1 Forum

Hi JayM,

I have oppened your .rar file.

In your view definition check that:

• There is something defined in your "Time" dimension subset.
• NONE of the subsets contain "consolidations" because you checked "Skip Consolidations"

I have repackaged your docx file and zipped it an included it in this post.

Hope this helps.

Hi

I have attached a .pro file here. Please let me know if this works or not...

Thanks

You have selected to SKIP all calculated (that is consolidated or non-leaf) values. The most important thing to check is that in the subsets in your processing view that ALL of the elements are of type "N" or leaf. Otherwise if any of these dimensions don't contain at least one N level element then you are skipping your entire record set, in which case you are getting the result you would expect.

Hi All,

Thanks a lot for all your help.. Finally I am able to do it successfully... I really appreciate all your help..

Thanks again..

Regards

JayM wrote:Thanks a lot for all your help.. Finally I am able to do it successfully... I really appreciate all your help..

For the benefit of others who may read this thread looking for solutions, please post what steps you took to fix your problem.

tomok wrote:For the benefit of others who may read this thread looking for solutions, please post what steps you took to fix your problem.

I had a consolidated value in my view which was not allowing me to put values in my cube with CellPutN.

***Following are the steps I took to solve the issue****

1) Created a view with Skip Zero/Blank values and Skip consolidated values options UNCHECKED .

2) Selected all the leaf nodes/values in the view.

3) Assigned contents of all the variables to OTHER under variable tab.

4) Under Data tab, "I have" used following code to put the values in the cube.
if(Value=0);
CellPutN(1, 'GL', Variable-1,Variable-2,Variable-3,'Actual');
EndIf;

5) Save and Run....