finding a value in the microcube/dataprovider

building reports webintelligence
1

I have been trying to find a way to put a specific tuple value to a variable in Webi but cant find the syntax. I like to do something like this:
variable qty=[qty] where [kampanj]=203,[year]=2009,[line]=“blue” but with the syntax for getting the [qty] value for the specific selection on the other dimensions.

Best regards Jesper

jeppe3333 (BOB member since 2009-12-07)

2

Jesper, welcome to B:bob:B! Could you please post the exact code here on the board along with the error messages if any?

Jansi :india: (BOB member since 2008-05-12)

3

Thx for answering

I dont have a code or error message I dont know how to write the code.

I like to create a dimension variable NewExtno with values [extno] minus the value for [extno] were [kampanj]=203 and [year]=2009 and
[line]=“blue”
and use it in a crosstable.

Best regards Jesper

jeppe3333 (BOB member since 2009-12-07)

4

Try something like this:


[measure1]=max(if([kampanj]=203 and [year]=2009 and 
[line]="blue";[extno]))

The max function forces Business Objects to return the same value for each row of your block.

Then create a measure like the following:


[measure2]=[extno]-[measure1]

You might need to use context into these equations to get them to work exactly the way you need them to work. If you could layout how the data is coming we might be able to give you a more specific solution.

jbarnes794 :us: (BOB member since 2008-06-13)

5

Thx,

I try that.

Best regards Jesper

jeppe3333 (BOB member since 2009-12-07)