Have a quick question. Have time to answer?

In 2000, there were only dimensions and cubes.

In 2005, they add the views which dimensions build off of. Have a solution
with 3 views. Have 3 cubes. Have a dimension that is used amongst all three
cubes. Well, first of all 2 cubes was created in 200 and just updated to
2005. Creating a new cube with a new dataview and a new factorder table. But,
would like to use the same dimension cause there is no point in having a
different dimension. But, when I process the cube, everything process fine.
But, when I browse the data, it does not seem like the data is breaking
properly on the dimension. Hope I did not confuse you.

The dimension is a customer dimension. Hierarchy is "Customer Network -
Customer #". In the previous 2 cubes, here is an example

Quantities Date
Jan Mar Apr May
Customer A 1 0 2 3
Customer B 0 2 1 0
Customer C 0 0 3 5

In the new cubes, here is an example

Quantities Date
Jan Mar Apr May
Customer A 1 2 6 8
Customer B 1 2 6 8
Customer C 1 2 6 8


Any ideas. I can create a brand new dimension and build it from the dataview
that is being used by the cube and it works. But, then I have a dimension
that is pretty much the same as the existing one.

Roger,

Are you using user defined hierarchies? Have you defined attribute
relationships. I had a similar issue where data was getting duplicated and
it turned out to be related to attribute relationships not defined correctly
in a dimension. 2005 is a little more trickier than 2000.

Best Regards,

Joe

"Roger" wrote:

tell me about it. Found I needed to link it in the dimension usage tab as
well. Thanks.

"jgb23" wrote: