cancel
Showing results for 
Search instead for 
Did you mean: 

Restricted key figure in universe

Former Member
0 Kudos
76

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

In Select Statement - enter TableName.SalesValue

In Where clause - enter Tablename.Division='Fruit'

Object qualification should be measure

Former Member
0 Kudos

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...