BW time variables and WebI input controls

[Former Member]

Hi!

I'm working on a BW-WebI scenario for group reporting purposes.

One report consists of a couple of characteristics and two restricted key figures, with different variables per column concerning Fiscalyear/Period. One is for user entry of the actuals and the other is userexit for comparison with the same periods last year.

In the report I want to work with indata controls. This is a very nice way to filter the available data on different dimensions.

I don't want to allow the end users to be able to run the query on the bw database ad they should not have to see any prompts (variable screens). They should just use the indata controls.

Perhaps I do not need any time restricting variables in BW (created in query designer)? Perhaps they will not wok well together with the indata control for the time dimension?

When altering the input values via the indata controls, does this override the values/restrictions set via the prompt (variable)? Can I control both column restrictions via the same input control (since they are based on the same ifo object 0FISCPER in BW?

What is the best practice for handling this scenario?

Regards,

Fredrik

[Former Member · Accepted solution]

If amount of data is big you must restrict from BI if not you can handle all the data from BO

Regards

[Former Member · Accepted solution]

Thanks,

The amount of data is small (<100 000 records in cube).

I'm not sure about the best practice solution for handling the users requirement regaring drilling on the time dimension.

i don't want the end users to refresh data (read from BW database). The refresh will be performed on schedule from inforview. I would like to read data, perhaps limiting it with a bw time variable + a bw "offset"-variable for last year's data in two separate restricted key figures. But then I don't know how the users will be able to modify/filter the data considering the fact that the report consists of two different columns with different time restrictions (actuals + last year's same periods).

Is it possible to create "sub-variables" created directly in WebI for filtering ad-hoc? Say I load actuals data for period 001.2010 - 012.2010 into column A via the refresh (SQL) of the BW data and automatically (via offset variable) get last year's data in column B. Furthermore the end user wants to see data for period 007.2010 - 009.2010 without hitting the database again (since this takes time and the prompt is not very pretty in WebI) The data is already in the BO cache so I should be able to update the data in column A to the new time interval and get column B to update accordingly automatically following the figures in column A.

Is this possible to do in WebI? Is there some more clever way to do it?

Regards,

Fredrik

Edited by: Fredrik Carlsson on Dec 22, 2010 9:31 PM

[Former Member · Accepted solution]

Ok...but im talking about the data that query brings from cube if the query with out filter brings you all the records it depends on performance if you want to get it all to BO if it not have a good performance you must restrict the data from BI.

Another option that i always use is to partitioning the query if you have a query with 5 characteristics you must create a webi with 2 or 3 and create another one with the detail of the other 2 ans using the first 3 as filters.

Regards