on 03-22-2011 5:42 AM
Dear Friends,
We are using SAP BOE XI 3.1 while our datasource is SAP BI 7.0.
i am creating a universe and i want to create on calculated measure like.
Sales value where Division = Fruit.
we already have Sales value as measure
and Division as charaterstic.
How can i achive this scanario.
Regards
Naeem
Hi,
In Select Statement - enter TableName.SalesValue
In Where clause - enter Tablename.Division='Fruit'
Object qualification should be measure
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In Sales Value measure object
Where Clause:
TableName.Division='Fruit'
Otherwise Create a Prompt:
Fruits.Division IN @Prompt('Choose the Fruit Name:','A','Sales/Fruit',Mono,Constrained,Not_Persistent)
simple try this in Web I Sales Value with above prompt.
All the Best,
Madhu...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.