TM1 Forum

All greetings.

I have problems with the report in Cognos Report Studio.
I have 2 cubes TM1. 2 cubes TM1 - sources for the report.

Cube 1 dimensions:
items1
time
measurescub1

Cube 1 dimensions:
items2
time
measurescub2

In Cognos Report Studio I should make the report of 2 pages
1st page - cub1
2nd page - cub2

In Cognos Report Studio I should make Promt Page.
In Promt Page I should make the filter on dimension ' Time '.
The filter should work for Cube 1 and Cube 2.

I do the filter. A source of data for a filter variable - query.
Query takes data from dimension ' Time '.
But Query takes data from dimension ' Time ' FROM one cube (from cub1 or cub2)

Result:
In the report the filter only for one cube is carried out. For a cube - a source of data dimension ' Time ' for the filter.

For the second cube - the filter is not carried out - there is an error
The model item ' [Cube1]. [Time]. [Time] ' is invalid.

Сub2 Does not understand the filter on dimension ' Time ' from cub1

Somebody faced such problem?
Thanks.

This is a basic question about filtering in Cognos BI Report Studio - not necessarily a TM1 question. Your prompt page will use a query to fill the values of the prompt with values from one of the cubes i.e. cube1. It will fill a Parameter with the value selected by the user: e.g. TimePrompt. That Parameter will be shared by each of your 2 separate report pages. Assuming that the Time dimension is shared between cubes, then the list of values in the prompt should be valid for both cube1 and cube2.

Now each of your report pages is bound to a separate query (e.g. Query1, Query2). Each of those Pages should be filtered differently.

E.g.
Report Page 1 should have a filter like:
[cube1].[Time] = ?TimePrompt?

Report Page 2 should have a filter like:
[cube2].[Time] = ?TimePrompt?

Thanks for the answer.
But your decision does not solve a problem.

MarioRubbo wrote:That Parameter will be shared by each of your 2 separate report pages

The parametre made on a basis dimension ' Time ' from one cube (cube1) does not work for other cube (cube2).
Cognos BI Report Studio gives out an error for the filter for cube2.

Can I get dimension ' Time ' by means of MDX inquiry for server TM1?

Thanks.

If I understand your original post, the reason you get the error is because you have a filter statement on the query for Cube2 that references a data element from Cube1. It should be a simple syntax change to modify the filter on Query2/Page2 to reference the Time dimension from cube2. The query in Page2 gets all of its elements from Cube2 so there should be no reference to any elements from Cube1. For the query that fills the Prompt page, you have to arbitrarily select a cube to pull values from the Time dimension. Assuming that the same dimension is shared between cubes, it shouldn't matter which cube you pull from to fill the prompt dropdown.