How do we use the items in one dlist to calculate another dlist?

[Radhika]

Hi All,

I have 2 dlists, let say dlist 1 is,

A
B
C
D
total

Dlist 2 with some condtional statments

A1
A2
A3
A4 In A4 cell, the calculation is ('Total' from dlist 1 + 'D' from dlist 1)*1000

Can anyone let me know how this can be handle?

Thanks in advance....

R

[vishalbhandari]

hi radhika,

cross referencing another dlist itema in a calcuation isnt allowed.
You can add another item to the Dlist (with items A1-A4), say "A5" and run and internal Dlink.

You will need 4 internal Links. The mapping for the link will be

D and Total will be selected from the source(Unmapped) for all the links, as you want the sum of the 2.

A1-->A5; A will be selected in the target unmapped)

A2-->A5; B will be selected in the target (unmapped)

A3-->A5; C will be selected in the target (unmapped)

A4-->A5; D will be selected in the target (unmapped)

You can then use A5 to reference your calculation for A4

[Radhika]

Thanks, Vishal.

[aa2288]

Also consider why you need two separate Dlists. Your required functionality may be achieved by combining these two dlists into a single dlist.

[branko]

Also consider why you need two separate Dlists. Your required functionality may be achieved by combining these two dlists into a single dlist.

Sure - I wonder :-) what can be these d-lists about... maybe could you provide us with the more concre example ? .... I am afraid that using "running internal links" to solve this - could help technically but - it will not address the logical problem in that solution - that i am afraid there is... (the more concrete example - can help me to advice a bit more...)...

[Radhika]

Thanks,

First dlist gives info about employee..current count (item 1), Budget count(Item 2), Deletions (Item 3), Total.

Second dlist HR cost calculations.... Like relocation cost, salarypa, gratuity and visa cal etc;

we use the Total (item) from dlist 1 to calculate the visa expenses in dlist 2

calculation: (Total(dlist 1) + Delete (dlist1))*12

Thanks
R

[branko]

Well, not being an HR expert, but looking on this problem strictly "d-cube purpose" focused i would not create one cube for this (if i understood it correctly) i would think about creating at least 2 cubes :

1st : "Headcount calculation" - focused on employees counts - with the dimension you mentioned (maybe would add some more business value for it & enhance it) like :

1_Headcount_Calc :

OPENING  Current Count
New employees
Deletions
CLOSING Current Count

(& maybe used BIF FEED for it / or manual calc. - its up to you - but have a look at this bif - default installation analyst library "bif" - cube feed).

2nd : "Salary_Calc (or Wages or Personal_Cost_Count..)" - instead of counts focused on money (costs) - some of which could be fixed, some predicted based on some drivers and much of them comming out from the 1st cube - so there will be a link transferring the beginning (ending or avg.) count of employees for each month and a calculation focust on personal costs.. like :

2_Salary_Calc (or Wages or Personal_Cost_Count..) :

Based Salaries
Benefits
Vacations (payments)
Sickness absence
Yearly bonuses
TOTAL PERSONAL COSTS

Comming back to first two items in "your" firs dlist - current count & budget count - i would not use it this way. Instead I would create a special dimension of versions with items ACTUALS, BUDGET, FORECAST ... Why should i be satisfied comparing ACT/BDGT for only employees counts ? what about the total basic salaries ? total personal cost ? the whole sickness absence ?...

Maybe there should be also a 3rd cube - focusing on salary brackets and a base salry for each salary brackets - then you shold be also able to what-if-simulate :-) What would be the impact of rising salary brackets no. 3 by 10 % on the income statement, EBITDA, EBIT, Profit / Loss...
(& if it maybe will be a bit different than you propose to customer - i am sure this could attract their attention so much :-) that there will be a space for discussions & compromises....

[lav4you]

Thanks,

First dlist gives info about employee..current count (item 1), Budget count(Item 2), Deletions (Item 3), Total.

Second dlist HR cost calculations.... Like relocation cost, salarypa, gratuity and visa cal etc;

we use the Total (item) from dlist 1 to calculate the visa expenses in dlist 2

calculation: (Total(dlist 1) + Delete (dlist1))*12

Thanks
R

Hi Radhika,

I am still not clear about whats the exact calculation ur looking for.. but I guess creating one dummy item and two internal links can solve this problem

Create a dummy item Total + Deletion and create link for Total in fill mode and
Deletion in add mode
this will get the sum of Total(D-list1)+ Deletion(D-list1)

Now another item Visa Exp Calc will be Total + Deletion * 12


Let us know if it works...