Can you detail your requirement. Actuall we can't restrict a key figure with another key figure. But let us know the requirement. Will check if we can put some logic to restrict.
i need to calculate the invoices for Purcahse orders and non Purchaseorders
PO NonPO Total.
Inovoice
in the cube i have invoice items,invoices
ex:Invoice No invoice item PO/NonPo indicator
500001 10
20
30
5000002 10 x
20 x
30 x
5000003 10 x
20 x
30
in the above i have three purcahse documents are there.
if i count above things
i need to have follwoing result
PO NonPO total
invoices 2 2 3
how is means in the above one Purcahse doument is pure Po only all items are belongs to Purchse order only. second one is pure NonPo and third one some items are Po and some otheres are Non Po.
so i need to calculate at items level whether it is Po invoice or Non Po invoice.
here we dont want to change any thing at cube level.
any body idea like how restict one key figure restict with another keyfigure
One more thing is in my current cube i do not have any Purchase document No and items are there.
Amith try using with New formula in the columns using count function. You can use count function for all and then using a new formula you can build logic to diffrentiate the PO, Non PO and also total. I believe this can be achived as I said above.
here problems is first we need to count the invoices based on the invoice items. why bec in invoices some items are po and some are non po so first i need to restict invoice on invoices item. there is no problem for differentiate the Po and Po.
Well Amit, create a CKF to count PO and another CKF to count NonPO. use them in the new formula and build logic with teh key figures. i need more inputs to proceed further I believe.
here i am able differentiate the PO and Non Po keep in the column and put some indicator. it is automiticatlly taking PO and Non Po only problem is before that i need to count invoices based on the items. as i discussed earlier.
invoice count,item count are key figure, Po and Non Po char.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.