MultiCube Queries - Inventory

[Former Member]

I have built a multicube which includes the daily load inventory cube and a snapshot inventory cube. The idea for this is that I am building a workbook which will include the daily stock overview query and a monthly stock overview query.

In order to show the daily load as part of this workbook I have had to add the 0CALDAY time characteristics. In the monthly stock overview we want to select fiscal periods time dimensions (which we have included in the multicube) is this feasible if so how and is there any impact because we have 0CALDAY granualarity? Thanks

[Former Member · Accepted solution]

Hi Niten,

The problem can arise in query where both information are displayed: daily and period stock.

For these kind of query you must use Restricted Key Figures, one restricted on Day and one on Period.

Ciao.

Riccardo.

[Former Member · Accepted solution]

Thanks for that, what I am doing is as follows:

1) Daily Stock Overview - I have just copied this from the Standard Daily cube and at the moment there are no plans for any changes

2) Monthly Stock Overview - I have different key figures and none of these for the moment are from the daily InfoProvider cube.

Do you feel that I will still need to place a restriction or should this be okay?

[Former Member · Accepted solution]

Hi Niten,

Using a workbook you only have to introduce query on daily and period key figures.

You will not have any kind of problems also becuase Key Figures are different and the queries are with different selection for time.

Only remember to do not introduce in drill down the time CH, becuase in this case you will not be able to match directly the values.

Restricted Key Figures are usefull only for data all in a single query, not for workbook where different selection are for different queries. In previous topic I didn' t consider Workbook specification, sorry.

Ciao.

Riccardo.

[Former Member]

There is no impact in granularity. Each cube has its own granularity, one per day and the other one by month. Multicube is a view and it doesn't contain any data, then granularity is a term that there in no relation with multicubes.

[Former Member]

Thanks for that, I may need to have a mixed time scenario but will post a seperate question once I have more details