Cognos dynamic cube with stand alone / New table, no relationship with fact table

Cognos dynamic cube  with stand alone / New table, no relationship with fact table

Separete new table / dimension need to publish in cognos dynamic cube package without joining fact table - wihtout relationship with fact or dimension table, New table means just stand alone table.

Steps:

1. Get Table ready in Database
2. Create new dimension with new table
3. Drag new dimension under existing cube
4. Drag new dimension out of existing fact table (trick is here : Don't put inside measure folder new dimension move to outside of measure folder )
5. Need to define relationship to existing fact table because its (new stand alone table) has no relation with existing fact table.
6. Validate it and publish the cognos dynamic cube package

Cognos dynamic cube with stand alone / New table, no relationship with fact table

Cognos dynamic cube  with stand alone / New table, no relationship with fact table

Separete new table / dimension need to publish in cognos dynamic cube package without joining fact table - wihtout relationship with fact or dimension table, New table means just stand alone table.

Steps:

1. Get Table ready in Database
2. Create new dimension with new table
3. Drag new dimension under existing cube
4. Drag new dimension out of existing fact table (trick is here : Don't put inside measure folder new dimension move to outside of measure folder )
5. Need to define relationship to existing fact table because its (new stand alone table) has no relation with existing fact table.
6. Validate it and publish the cognos dynamic cube package

Dynamic cube error attached.

If you are facing issue dynamic cube error.


..\data\relmd_HRMTGT_HRMTGT_dbo.xml (Access is denied.)

Solution 1. Make sure you should have access to cognos installed location , admin shold be good.
Solution 2.  Just open cognos dynamic cube as administrator.

your problem solved
 

One cognos filter and multiple behaviour

If I select query1 for 2016 automatically I can get query2  data minus1 year and querey3 data minus2 years
Automatically my below three query will filter..
[Contract_YYMM]=?yrm?
querey -2
[Contract_YYMM]=
cast(substring(Cast(?yrm? as char(6)),1,4)-1 as char(4))
+
cast(substring(Cast(?yrm? as char(6)),5,6) as char(2))

querey -3
[Contract_YYMM]=
cast(substring(Cast(?yrm? as char(6)),1,4)-2 as char(4))
+
cast(substring(Cast(?yrm? as char(6)),5,6) as char(2))