November 18, 2003 at 9:43 am
Using a 3 dimensional cube with one distinct count measure as a data source, I have created a pivot table in Excel. One dimension is on the row, one is on the column, and one is in the slicer/page.
The problem I am having is that when I select multiple members within the page/slicer dimension, the pivot table returns the #VALUE! error within the data cells. This does not occur when I view one member at a time, or select all of the members within the slicer dimension.
Can anyone offer any insight to the cause and/or solution to this problem?
Seth Manchik
Seth Manchik
November 18, 2003 at 9:09 pm
Distinct count is a problem when you have it in the same cubes as other measures, best way is to create one cube for the distinct count, another cube for the other measures and then a virtual cube to use to query, sounds arduous but as most will attest to, distinct count is a pain.
HTH
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply