I am facing an issue in building an List report using cube, am not able to use more than 4 columns from cube( getting an error exceeded number of tupples)
(building a child report where they need to display dimension info like project, project desc,status,manager name...... like wise around 8 columns but no measure is used in this report)
Any Ideas ??????any one build a list report using cube which includes more than 5 dimensions.??????
which version is it?
I am using cognos 10 report studio
is this possible ??????
Working absolutely fine for me on Cognos 10.1.1. Published cube as a package and created a reports with 5 dimensions and a fact. Just in case, check if there any properties set on your cube.
Thanks
Prasan
Did u dragged the dimenssions from the same hierarachy or they are from separate hierarchies as well.
Ex Cube stores data for all the dimenssions,
Status cloumn
Amber
green
red
Project
abc24
cde25
fde35
when u run the report using FM package data with count as measure dat will be like,
abc24 amber 1
cde25 amber 1
fde35 red 1
where as when u run using cube package,
abc24 amber 1
green 0
red 0
cde25 amber 1
green 0
red 0
fde35 amber 0
green 0
red 1
Like the above example ,
when we have multiple dimenssions then more combinations occur and finally results with an error "Exceeded number of tuples"
Hi
Sounds like you've set the dimensions in your cube to always be included (which may be why you're getting zeros coming out in the count). Try changing this to be included when needed (I think this is a property of the attribute)
Alternatively supress zeros in your report.