How to get year-1 from the prompted year - ( offset )

[Former Member]

Hi There BO Experts.

I am used to SAP BW and now I am learning BO. Currently working on a BO Web Intelligence solution.

I am struggeling with variables and prompt.

I would like the following solution.

The user is promped for year - that is the current year.

Based on this I want to be able to make a query selecting only last year.

In sap BW we have something called offset on variables. I havent seen that in BO.

Does anyone have a solution ?

Points will be given.

Best Regards,

Ingrid Husby

[Former Member · Accepted solution]

Hi Ingrid,

Refer to the product guide [http://help.sap.com/businessobject/product_guides/boexir3/en/xi3_sap_olap_universes_en.pdf]

See the section on "Calculated measures in OLAP universes" where I think you could create a prompt for year then - 1 from the imput.

My senses tell me that if you coded the BeX query with the offset on the variable it should work as the object in the universe will pulled to prompt though from the BeX query...

Dunno?

Jacques

[Former Member · Accepted solution]

Thank you Jacques.

I found another link with about the same problem, where the suggested solution was to create an alias for the time dimension in the Universe.

I will try this first now.

Thank you for the link as well.

Ingrid

[Former Member · Accepted solution]

Hi Ingrid,

Sorry, I thought you were doing Webi on universe off BW...

If you are using a database behind the universe, you create a filter object in the universe using the @prompt function...

Year = @prompt('Enter Year','C',,mono,free) - 1

Hope this helps

Jacques

[Former Member · Accepted solution]

Hi Jacques.

I have made an object in the Universe no.

With year +1 as value. Then when I promt for year, it will give me year -1.

It is working well, but I get into some trouble in the merging of all these queries.

THanks for your help !

Ingrid