TM1 Forum

I have a subset that refreshes nightly .

Is there a way i can refer that subset in a dbrw to retrieve cube value .

Thanks,

I have the below mdx to select the 3 items in level 3 {TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER({[Items].[All Teams].[50].[50 - 5].[50 - 5 - 406],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 407],[Items].[All Teams].[50].[50 - 5].[50 - 5 - 409]}, ALL, RECURSIVE )}, 3)} now i need modify the mdx to choose...

Hi, I have to replace a subset value in place of hard coded month in the below DB expression ['Average DSO'] =DB('AR History', !Customers SoldTo Only, 'US01', 'Jul 2017' , 'All Currencies', 'Local Currency', 'ASSETS', 'All Customer Types', '6 month DSO'); I have a subset name called Months - Prior M...

Hi, I have this mdx . { ORDER( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Months].[FY2017]}, ALL, RECURSIVE )},0)} , [testcube].([Sales Measures].[Full Revenue],[testcty].[usa]), BASC) } here instead of [testcty].[USA], I have to replace a user variable vcountry from my variable tab in a ti process. C...

yeah , i was asking in the below scenario it returns me the sorted months by sales, is there was a way I could directly get the sales value directly ,

without using cellgetn

Thanks,

Okay I got this working to sort my months based on a customer sale . { ORDER( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Months].[FY2017]}, ALL, RECURSIVE )},0)} , [testcube].([Sales Measures].[Full Revenue],[testcty].[usa]), BASC) } This returns me months in ascending order with sales value for USA ....

Hi , I need to find a median for customers in a 12 month period sales . I know we dont have a formula in tm1 for median . so for work around , I have the cube with customers, 12 month sales data. I am planning to write a ti process on the customer subset . Take each customer and write a mdx which ta...

okay ima trying to replicate average if not equal to zero in tm1 rule .

May be i wil do it for 2 months first .

I dont think so its straightForward .It will have multiple ifs for 2 months only .

I just want to know if there is an equivalent formula in tm1 to write the rule for the below calculation 1 and calculation 2 .
If so can you please let me know how to write that calculation.

Hi , I am planning to build a credit scoring model in tm1 based on last 24 month sales of customer . Ideally this should have been done in excel after exporting the data in tm1.But however i wanted to try if the calculations are able to performed in tm1 . Calculation 1 : I will have 24 months of sal...

Hi, I am planning to write a ti process to carry forward ending balance to beginning balance of next month via ti. I have my data starting july 2015 in my cube , i should now start carry forward july ending balnce as august beginning balance . For this I will create a ti with datasource as a view wi...

Okay I am using the below code to remove my levels from hierarchy in my dimension,This is the only one I can think of where the dimension element is touched again. This will remove the element from its parent and put seperatley. vMax = DIMSIZ(vDim); vCount = 1; WHILE (vCount <= vMax); vElem = DIMNM(...

Hi we have an issue at times were the public subsets created on dimension gets cleared randomly.
Can yuo guys tell me where should i start trouble shooting this .

Some times it happens after server restart , sometimes it happens randomly when server is running.

Thanks,

Hi, I want the blank stock category rule to be applied to n and C level of ending balance ['Ending Balance','Inventory Stock Category':'Blank','Total Extended Cost']= IF(NUMBR(ATTRS('Months', !Months, 'Month Number')) > 201601,['Inventory Stock Category':'Blank','Total Qty on Hand']*DB('Cost Sets', ...

so my rules when tested are in order ['Ending Balance','Inventory Stock Category':'Blank','Total Extended Cost']= N:IF(NUMBR(ATTRS('Months', !Months, 'Month Number')) > 201601,['Inventory Stock Category':'Blank','Total Qty on Hand']*DB('Cost Sets', '1100', '10', !Currencies, !Months, !Materials, 'St...

I have a view as in below screenshot . I want to apply 2 rules to an element . Is it possible to do so . SO one rule is ['Ending Balance']=IF(NUMBR(ATTRS('Months', !Months, 'Month Number')) > 201601,['Beginning Balance']+['ALL Movement Types'],stet); And other rule is based on other dimension stock ...

Hi, I have a Inventory cube with five dimension. Material, Months,Mesaures,StockCategory,Movemnt type. For Movement types , we have three elements Beginning Balance, Ending Balance and Movement types. Here Movement types has many movement types like 101,102 etc..Here I had the ending balance as a co...

Actually the Ending balance is consolidation . I think I am doing some thing wrong here . Let me reexplain the scenario with example .

Hi I have a dimension which has elements like Beginning Balance , Ending Balance and All Movement Type. Ending balance is the consolidation of Beginning balance and All Movement types . Now there is a dimension called stock category which has values like Blank or in transit . For intransit the cost ...

In ops console, the rule attach function is running for all other cube feeders.