COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Mpotla on 27 May 2009 10:00:12 AM

Title: Star Schema Grouping
Post by: Mpotla on 27 May 2009 10:00:12 AM
Hi All,

I created a joins in the physical layer with few dimensions and role playing dimension(alias), the joins are looking fine in the database layer, when i create the star schema grouping, Its taking only the fact and dimensions joined to the starschema grouping.

I copied the role playing dimension to the star schema layer, But its showing the alias as the Orphans, so i create the joins again.

Suggest me ,If there is any of creating the starschema layer containing the alias or shortcuts

Thanks in Advance!