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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Performing distinct count without using category count in Transformer
I am able to perform distinct count using Impromptu IQD However, when this distint count is placed in the cube, how do I resolved Quarterly and Yearly roll up the cube that adds the number instead of maintaining the distinctness of the count on these levels.- 123498765
- Post #3
- Forum: Cognos solutions
-
Performing distinct count without using category count in Transformer
Hi all, I am currently designing a Cognos Cube and need to show distinct customer counts from a transaction detail table in my database in this cube. There are currently over 25 million records in this table. If I was to use the Category Count functionality in Transformer, the cube size would...- 123498765
- Thread
- Replies: 5
- Forum: Cognos solutions
-
Associating External Roll up on more than one dimensions
Hi All, I am currently trying to use external roll up to depict summary data in a cube. I have used the example model "Great out doors(Admin).mdl" as a cookie cutter. However, the example in this model only applies to one dimension, the time dimension and not any other dimensions...- 123498765
- Thread
- Replies: 0
- Forum: Cognos solutions
