TM1 Forum

Also I tried this with just one dimension on filter condition . {Count(Filter({TM1FILTERBYLEVEL({DESCENDANTS([Customers SoldTo Only].[Region - 001 - CROSSROADS - CROSS040]) }, 0)},([AR History].[AR Measures].[Recent Activity]])=0))} But does count makes logical to have here ? Will it give the count ...

Hi , I am using the below mdx on an insert subset to test the results . {Filter({TM1FILTERBYLEVEL({DESCENDANTS([Customers SoldTo Only].[Region - 001]) }, 0)},([AR History].[AR Measures].[Recent Activity],[AR History].[Months].[Feb 2018])=0)} I want to check the value of Recent activity for all the n...

Thanks for the suggestions. I cannot spread 1 as I will also have to do some conditional check to see if the customer is active based on another measure.

Hi, I have a cube with customer dimension which has an hierarchy like Region ->Agency - > Rep-> Customer Now the cube has measures based on the customer loaded like recent activity , balances, sales etc . Users wants to know the count of number of customers for each region and each agency . Now I pl...

this code doesn't work if I have more than 1 child .

Example

Car-> camry->level1 ->s4

iterate all n level , we get s4 ,

now only s4 and its parent level 1 is copied to the new dimension . I still wanted camry and car .

Hi, I have a dimension say car which has elements with parent ,child relation with different levels. car-> Toyota->SE,LE,XE Hundai->Model1->XSE now I need to copy all these elements to another dimension say 4 wheelers with a parent child relation in car I will create a subset of all N level in car d...

Okay its working now . Thanks for your help on this and putting so much time to explain . I am still confused with logic and will take simple example . Only tow days of sale Sale CumSale 1 100 100 2 50 50 1 MTD - 1 and 2 MTD - 2 ,1 So rule [CumSale]= DB ('Trend',!Day|'MTD', 'Sale'); so for feeder he...

so for day 3 my rule was based on 3, 2MTD and 1MTD . And we created a consolidation called days!|'MTD' which included 3,2 and 1 . Now for the same day 3 which days are my feeder dependent and how should the consolidation here be . Can you please tell me how my consolidation for feeder should be and ...

Okay please ignore me if I am being very basic . so assume I have days 1 to 31 and I have sales only for days till day 5 . I have my view with days 1 to 5 and columns with Daily H) and MTD H0 . so the rule says , ['MTD H0' ] =DB('Daily Sales Trend', !Customer Regions, !Days Trending|'MTD', !Months, ...

can you tell me the syntax in this case to consider Day trends for feeder . I think I am not understanding clearly , but by looking at the feeder I should be able to relate it. I tried something like this , but didnot work . ['Daily H0 - Accumulated' ] =>DB('Daily Sales Trend', !Customer Regions, !D...

I think I will make it simple I have cube with days like Sales MTD H0 RPD 1 100 100 100 2 222 322 111 3 222 544 181.3 4 100 644 161 5 600 1244 248.8 Now MTD H0 is a rule and it uses the below rule and feeders . ['MTD H0' ] =DB('Daily Sales Trend', !Customer Regions, !Days Trending|'MTD', !Months, !P...

No this is not working .Still the same ,

Guys any help on this .

SkipCheck; ['MTD H0' ] =DB('Daily Sales Trend', !Customer Regions, !Days Trending|'MTD', !Months, !Product Lines, 'Daily H0 - Accumulated'); ['RPD' ] =['MTD H0' ] /ATTRN('Days Trending',!Days Trending,'DayNo'); ['PTQ']= ['MTD H0'] /DB('Daily Sales Trend', !Customer Regions, '1', !Months, !Product Li...

I was able to do the consolidated element in the dimension itself . How do I calculate it in the TI process when you load the data in the first place, probably best for performance ? Should I do a while lopp or if loop for each day and sum the values and then store it , consolidation on dimension lo...

Hi , I have the below scenario and would like to calculate a new measure which will do the cumulative total . Region 1 Days Daily H0 Cumulative H0 1 120 120 2 100 220 3 150 370 4 200 570 5 33 603 6 50 653 I am expecting the calculation for Cumulative H0 based on my daily h0 based on days . Can you t...

Hi , Deleting the rules and restarting the server and recreating the rules fixed the issue . Thanks so much for all help . Now I have a another question related . With same example , ['Average TurnAround Time' ] = ['TurnAround Time']\ ['Cases with TurnAround']; ['TurnAround Time'] =>['Average TurnAr...

TThanks for taking time to give the sample code . But Can you tell me whats wrong in my other post . I had done it after reading about feeders tutorial and would like to know why feeding is not happened . I have posted the rule tracer and check feeders screen as well . . Instead of doing case count ...

Hi , I have read the IBM proven practices on feeders on recommendation of a forum member and half way through and they explain the basics clearly . I have an issue now with my feeder not being fed and disappears on zero suppression . I have a measure which gives the turn around time and other measur...

Is there a syntax ,if I reverse it showing up syntax error . DB('Dispute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Case Status, !Dispute Person Responsible, !Dispute Processor, !Dispute Reason, !Dispute Root Cause Code, 'TurnAround Time') => ['Average TurnAround...

Hi, Okay this is what I got and I want some advise on how this works . Working Rule and Feeders : Skipcheck; ['Cases with TurnAround' ] =N: IF( ['TurnAround Time' ] > 0,1,0); ['Average TurnAround Time' ] = DB('Dispute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Ca...