Hi! Guys,
Can you help me with this?
I have a view which have data. I set this one dimension as the row dimension of the view. But when I slice the view, an activeform, the excel doesn't show any element from that row dimension making it appear with no data at all. But the cube viewer shows data.
One observation is that, the column A is not hidden because it is not successful. Another is, the TM1RptRow formula is present in the cell but still it doesn't display even a single element. The said row dimension consists of less than 8000 elements (with repetitions already). I use Excel 2003. I tried rebuilding the workbook, but still no data.
Another observation is that when I change that row dimension by another dimension making the previous dimension now a title dimension, it returns all the data in the active form. Also, when I put another row dimension, I mean when I set two or more row dimensions in the view including the said first dimension, the view returns the desired data in the active form.
Does anyone know about this scenario? Can you help me?!
Thanks a lot!
No Row Element in Active Form
-
- Regular Participant
- Posts: 197
- Joined: Thu Dec 03, 2009 8:47 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2.x
- Excel Version: 2010
- Location: Singapore