Hello!
Here is the problem:

I have this table with the following columns: Key; ValueA; ValueB;
ValueC.
Key column is the variable that makes the connection between the fact
table and the dimension table.
And i want to create a dimension with ValueA; ValueB; ValueC; at the
same level!
Is this possible? Or i have to create 3 dimensions one for eache
value?

Thanks

Botinha

Hi

AFAIK,You will have to create 3 Dimensions

Cheers
Sank

----- Botinha wrote: ----

Hello
Here is the problem

I have this table with the following columns: Key; ValueA; ValueB
ValueC
Key column is the variable that makes the connection between the fac
table and the dimension table
And i want to create a dimension with ValueA; ValueB; ValueC; at th
same level
Is this possible? Or i have to create 3 dimensions one for each
value

Thank

Botinh

You can use a view

(simple example, depending on data types might need to be changed)

create view blah as
select a + B + C
from table

Then reference the view as a dim in your cube.

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Botinha" <botinha (AT) netcabo (DOT) pt> wrote