TM1 Forum

..

Hi all,

In my tax cube i want to put value in city because that are on leaf level
but i want the value same in conslidated level
suppose i put 10 in jammu city then 10 value should be in state jammu-kashmir.
i dont want consolidated value in state level.

here i am attaching my 2 cubes..

if u can see their is a grade element in Headcount cube
i just want to do if i select grade 6 in that element

then the value should be fetched from 2nd cube which is salary master

can u plz tell me how to attach screenshots to this reply??

i mean if i want to attch screenshot with post in this forum??

which element??
Grade??

Hello all, i used nested DB for my current task which is min salary as per grade. In my first cube i included grade element in measure diemension and also created picklist into grade element like 1 2 3 4 5. and in my second cube 1r_Salary_Count, Min salary value is there for 1 2 3 4 & 5 Grade. I...

Yeah Sure Sir..

But how we can attach screen shot with messages in forum???

thank you for your suggestion sir,

but i tried that
it gives error i think something went wrong.

hello all.., how can i reduce the code ??? it gets too lengthy if i want to write it for 12 months?? ['Travel Rate/Day' ] = N: IF(DB('2r_Hotel',!2a_Employee_Name,'Travel')@='Bus'& DB('2r_Hotel',!2a_Employee_Name,'Month Of Travel')@='Jan',DB('2r_Hotel_Expenses', 'Jan','Bus'),IF(DB('2r_Hotel',!2a_...

I am using DB() Already like...['Travel Rate/Day' ] = N: IF(DB('2r_Hotel',!2a_Employee_Name,'Travel')@='Bus'& DB('2r_Hotel', !2a_Employee_Name, 'Month Of Travel')@='Jan',DB('2r_Hotel_Expenses', 'Jan','Bus') but the code was getting to lengthy for each month adn each type i want to add all month ...

Hello all,, I want to use DIMNM & DIMIX function to get values from each month. In my cube their is travel tyle e.g Bus,Air,Train and Accomodation e.g Hotel,Apartment,Lodge i want value from another cube as per the selection from picklist e.g Travel Type=Bus, Accomodation=Hotel and Month=Jan the...