| joshkpeng@hotmail.com 2006-01-26, 4:58 pm |
| Hi -
I am getting unexpected results when I return the members from the
Filter Axis of a CellSet opened off the Adventure Works DW database
located on an Analysis Services 2005 server when using a client program
I had written. The program is written in C++ and uses ADO MD.
My provider string is Provider=MSOLAP.3;Data Source=9.30.168.131.
I opened the CellSet using the query "Select from [Finance]"
After performing the following calls:
spSlicerAxis = spCellset->GetFilterAxis();
spPositions = spSlicerAxis->GetPositions();
spPosition = spPositions->GetItem(0L);
spMembers = spPosition->GetMembers();
long memberCount = spMembers->GetCount();
I get a member count of 173 which I interpret as the single tuple found
in the filter axis from the result of executing my above query contains
173 members.
The 173 members consists of the root members for each hierarchy found
in the Adventure Works DW database.
Is this behavior correct?
I would have hoped that the CellSet would only return the members from
the hierarchies that are found in the Finance perspective. I was
expecting that the tuple would contain 25 members and not 173.
My Adventure Works DW database is straight from the CD. I did not
change anything.
Is anyone else seeing strange behavior working with Perspectives?
|