Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Crurraca2010
- Order by date
-
Report Studio Crosstab with changing Dimension
Hi, I am trying to build a "SCD dimension" with surrogate key in BI 8.3, I have: Dimension ========== ID_Dim BK_LEVEL3 BK_LEVEL2 BK_LEVEL1 1 BK1_L3 BK1_L2 BK1_L1 2 BK2_L3 BK1_L2 BK1_L1 3 BK3_L3 BK2_L2 BK1_L1 4 BK1_L3 BK2_L2 BK1_L1 FACTS...- Crurraca2010
- Thread
- Replies: 0
- Forum: Cognos solutions
-
SCD TYPE 2 Dimension in Transformer
Hi, Is it possible to build a SCD Type 2 Dimension in Transformer? I'm trying to join fact table and dimension with a 2 fields relation by name (date and dimension Id) but it doesn't work because dimension Id is not unique. ( to be unique we need both fields, date + Dim id) Any ideas? Thanks...- Crurraca2010
- Thread
- Replies: 0
- Forum: Cognos solutions
