Rule help needed-design issue

Post Reply
Analytics123
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

Rule help needed-design issue

Post by Analytics123 »

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 consolidation of Beginning and Movement types . But I think its wrong and have to have the ending balance as n level element and then write a rule to consolidate.

Stock Category has two values one is other and Intransit. For Intransit the value of stock is loaded via ti process and has to be retained .

Now the first rule is ending balance of July 2016 has to carry over to the next month beginning balance.This is working fine .

But my calculation for stock category other has to be rule based meaning
[ending balance, other]=[totatlqty on hand ]*cost
And ending balance with intransit will still use the same value loaded via ti .

Now my overall ending balance should give me the result of Ending balance other +Ending balance in transit values total .

Also If I define ending balance as N level then
ENding balance = Beginning balance + All Movement type will be an another rule .


From my requirement do you think the ending balancce has to be a consolidation or an n level , the issue is my stock category dinensions memebers total are calulated differently for other and in transit .


Thanks,
Post Reply