List report using cube as datasource

[sandeep.indhuru]

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.??????

[CoolP]

which version is it?

[sandeep.indhuru]

I am using cognos 10 report studio

[sandeep.indhuru]

is this possible ??????

[CoolP]

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

[sandeep.indhuru]

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"

[wyconian]

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.