Sunday, August 21, 2016

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

No comments:

Post a Comment