displaying member properties in PivotTable

[Andrej Horvat]

Hi!
Im trying to display Member Properties in PivotTable.
I have a cube that has one dimension called Products.
Cube
- Dimensions
- All products
- IDs (ids of the products)
- Member properties
- Product Names

There are only IDs stored there, the names of the products
are imported as Member Properties. When i add this
dimension to PivotTable, only product IDs are displayed
which is not very useful. Is there a way to get the
PivotTable to display Member Properties instead?
Thx a lot.

 

[SonOfXavier]

Yes there is way and it is done at the cube level. Actually at the Dimensions.

In the dimension property called Member Name Column, you can set which ever
column from your facttable to be the Name of the member property. The Member
Key Column (i.e. ID) is probably right now your default. The two can be
different.

I hope that helps,

Gordon

 

[Andrej Horvat]

Hi!

Your solutions seems to work. But the unfortunate thing is
that the cube has to be processed in order to make this
work. Is there no way that i could switch between showing
the ids and descriptions without having to re-process the
cubes? The problem is that im working with extremly large
DBs and processing time takes up 8 hours and more.
It seems to me that both IDs and descriptions are available
in the cube, so i only need to convince the pivot table to
show what i want.
Thx.

 

[SonOfXavier]

OK -- I am not sure what you want completely but...

The quick answer is no there is no way to flip the captions from one member
property to another in the Pivot Table itself.

If you just want to display the member properties in the User interface then
you can use the "Show properties in Report". This doesn't replace the caption
being shown right now, it will just show the member properties you want below
the pre-existing caption. Not a great solution.

I have written a program that uses ADOMD and the OWC Pivot to set the
caption based on a member property and then saves the XMLData in a SQL table
which is to be used to displayed the Pivot table report in a web portal.
(Working for the Canadian Government everything has to be bilingual and this
was the only way to get both French and English Member Captions since the
local ID setting thing doesn't work -- yet.) I would not want you to get to
involved with that as a solution though.

I am not sure why you would have to process the cube all the time because of
the other solution. It should only have to be done once really. Once you set
the name caption column at the cube level, the cube should always show the
caption as you set it. It shouldn't cause the cube to become unprocessed all
the time.

Anyways I hope that helped.

 

[Andrej Horvat]

Hi!

Well, I'll try to explain things.
I have a cube of products. Every product has an ID and
name. The problem is that the users must have the choice
wether they want the IDs or the names shown. Why? Let's say
i have more than one product with the same name.
Example:
ID Name
Coke1 Coca-Cola 0.5 <- this one is in a bottle
Coke2 Coca-Cola 0.5 <- this one is in a can

Now the user does not know which one is in a can and which
one is in a bottle. Thats when i need the IDs to be shown.
But if i want to switch between these 2 the cube has to be
re-processed. Thats the main problem. So im looking for a
solution that would allow me to easily (and fast) switch
between IDs and names.

btw: Im using OWC components with delphi6 win32 enviroment,
not .NET platform. Somehow im unable to find "Show
properties in Report" switch. I have VB installed also and
cant find the switch too. Can u give me a more detailed
description on where to find it?
Thx.