Hi All,
I found that Cognos transformer will be best fit for our requirement of customer count than IBM DB2 OLAP Server as they have a built in feature to count for no. of customers (Unique and non unique). To acheive the functionality of a unique or distinct customer count, we created a dimension as customer which has unique customer ids and have a measure which will count on that dimension. This exactly solves our problem.
BUT the catch is, it will not allow more than 65536 members or records under a dimension. The no. is derived from 2 power 16 and the field type of cognos dimension I assume to be of short integer. As we have more customers than 65536, it gives the following error,
"[TR1901] the number of children (or parents) of a catgory cannot exceed 65,536 [Drill] in Customer_Age_band_Fact.mdc."
Any idea on how to solve the problem. Or have I reached the limits of the product.? Any comments/Suggestions/input are most welcome.
Thanks and Best Regards
GK
I found that Cognos transformer will be best fit for our requirement of customer count than IBM DB2 OLAP Server as they have a built in feature to count for no. of customers (Unique and non unique). To acheive the functionality of a unique or distinct customer count, we created a dimension as customer which has unique customer ids and have a measure which will count on that dimension. This exactly solves our problem.
BUT the catch is, it will not allow more than 65536 members or records under a dimension. The no. is derived from 2 power 16 and the field type of cognos dimension I assume to be of short integer. As we have more customers than 65536, it gives the following error,
"[TR1901] the number of children (or parents) of a catgory cannot exceed 65,536 [Drill] in Customer_Age_band_Fact.mdc."
Any idea on how to solve the problem. Or have I reached the limits of the product.? Any comments/Suggestions/input are most welcome.
Thanks and Best Regards
GK