Hi,
I have 2 dimensions.
Customer and company.
a) User wants to have a multiselect prompt on company.
b) Once the multi-selection has been made, I need the top 100 customers from the companies that are selected based on the tuple value (below) in the following format.
Top 100 Customers Name || Company Name|| Actuals
Actuals is an intersection of a measure with a member.
tuple([Cube].[Measures].[Actuals],[Cube].[All Accounts].[All Account Categories].[Account Category 2]->:[PC].[@MEMBER].[Total Trade Debtors per Balance Sheet])
How should I do it?
Do you need the top 100 customers for the companies combined, meaning a set that will have a max of 100 members? Or do you want the top 100 for each of the companies?
Thanks a lot Paul. Yes, I need the top 100 customers for the companies filtered (selected). I don't need top 100 for each company as that one works.
Basically the report's duty is to find out top 100 customers who owe lot of money (debt) for the selected companies.
The top calculation is based on tuple(amount,debt). Debt is a member from account dimension and amount is the measure.
Based on this tuple, I need to find out the top 100 customers for the selected companies.
Hope this one gives a picture of what I want.
The easiest way to do this would be to aggregate the selected companies into a single calculated member, and tuple that with amount and debt. Or you could cheat and do something like:
topCount(customers,100,total(tuple(amount,debt) within set set(#promptmany('Companies','mun','default member')#)))
Paul, You are a star..It works..Problem solved..I wasn't sure how to add memberset onto a tuple. Now I know...
Thank you so much...