Dimensional Reporting Prompt question

[cognos05]

Hi ,

I have a requirement where i have like 1000's of customers in a dimension and there are only 3 customers belonging to a seperate grouping.

SO i have to have like a prompt which has values like 'All Customers' and other value saying 'CustomGroupedCustomer'

So when ever they select All Customers I have to slice on 'ALL Customers' and CustomGroupedCustomer had to slice on these 3 customers .

How do I go about achieving this .


Shoudl this be a static prompt with two values and in the query slicer i write an if else on prompt value and then do the slicing.

How do I do a slicing to select three customers .

Thanks,

[cognos05]

I did add a static prompt with 2 values  and then defaulted to all customers and then  in the slicer i did this

if(?Parameter1?='All Customers')
Then
([All Customers])
Else
(Total(CurrentMeasure within set set([cust345],[Cust346],[Cust347])))


Just wanted to confirm with you guys if this is the right approach .


Would also like to know if there is another approach where I could

Create a custom group called CustomgroupCustomer which groups 3 customers in to one member and then i iwll have my parent all customer node , then i will supply these 2 to a prompt and then slice accordingly.

how will this customgroupcustomer be created. As a set or a member ?

Thanks,

[Andrei I]

What is your source? DMR or cube?

[cognos05]

Cube.

[Andrei I]

In my opinion any common elements for multiple reports should be implemented as shared items (data items in the model, data in the datasource, layout components).
In your case you could create an alternative hierarchy with a new parent member containing 3 required children( similar to PP transformer implementation of period-to-date hierarchy).

[Francis aka khayman]

CustomGroupedCustomer = except([All Customers], set([cust345],[Cust346],[Cust347]))
ThreeCustomGroupedCustomer = except([All Customers], [CustomGroupedCustomer])

[cognos05]

Thanks