TM1 Forum

Thanks so much Wim... All Sorted.. Was just going round and round in circles with this..

Hi Wim, Thanks for that, but are you able to provide a sample using NValue please?. My Cube is called Budget_MK2 CellGetN('Budget_MK2',Nominals,Entity,Customer,Master_Customer,Account_Manager,BudgetCalendar,BusinessUnit,Department,Regions,Sales_Person,Version,BudgetAmounts) The last Dimension in the...

Hi gtonkin, any chance you could elaborate on that please, i'm not being lazy i just don't know how to google this stuff properly at the moment? Can i use that with vVAR = CellGetN('Budget_MK2',Nominals,Entity,Customer,Master_Customer,Account_Manager,BudgetCalendar,BusinessUnit,Department,Regions,Sa...

Thanks Jeff, one step closer. Now i'm getting this error message though "1110112","DimLHINT","Unknown","Unknown","Unknown","P1","HIH-OCC","SALES","AMERICAS","Jane Poulton","Budget 2019-20",&...

Hi, Thanks for replying, i found that on a IBM Fix link, and couldn't get it to do anything. What I’m trying to do is get the data out of the BudgetAmounts Dimension, Value Leaf.. In the Variables page, it shows the BudgetAmounts as a Element Dimension and the Value Data Element.. I've tried numbert...

I'm trying to create a TI Process to extract data from my Budget Cube into SQL Server and i can pass everything except the Value from the BudgetAmount Dimension. If i # out vVAR and just load 1 instead it works but i think the vVAR is trying to convert the leaf Value instead of the Number it's holdi...