Monday, March 26, 2012

members not shown in pivot table

Hi Guys,

Some members of my dimension are not shown when use it in a pivot table. To prove this, I've browsed the dimension using the Business Intelligence. I search the member using the Find member. filtered the data that were not displayed and the result showed me that the member exists.

Is there a problem with the structure of my dimension or with my data? How can I resolve this issue?

Please enlighten me on this one.

thanks in advance...

It is hard to say what is going on without actually seeing the dimension design.

Try first experimenting with smaller size dimensions. Try substituting dimension table in DSV with named query limiting only to the members you suspect not seeing.

Hope that helps
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

No comments:

Post a Comment