Dear Gurus,

One of my client is analyzing sales data using Excel Olap and Analysis
Server. One of their requirements is that the name of the product, can have
two names: i.e.
A101 Adapter
or
A101 Multi Purpose Adaptor

How can I implement this in a way that the client can choose a dimension to
change the name of the same product item. amount of sales related to the
item remains the same. if it can be implemented via a click or so, it would
be ideal to client.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003

Hi,
since 1 product can have n names, why not add another
level to your product dimension:

product group (1:n) product (1:n) product name

That would require collecting base values for each
product name of the product, I guess. Which in turn
changes the granularity of the cube.
But why would one use two names, if they both mean the
same (measurewise)?

HTH Lutz

What I am looking for is just like the "long Name" or "Short name" as used
by Conogs Powerplay.
at the switch of a click to change the names. however, this can only be done
via Transformer in Cognos
for Powerplay to work that way. I am using Powerplay and Excel as my
frontend to connect
directly to analysis server.


"Lutz Morrien" <nospam.lutz.morrien (AT) ocb (DOT) com> wrote


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 20/08/2003