Thank you very much all

Thank you very much

All the replies were so useful

Hi, I've solved my problem as using a bridge table i could get the measure of a fact table sur an axe analyse(dimension) which is not lied directly to fact...

D'abord je n'ai pas compris comment vous avez su que je parle francais mais merci c plus facile:)

Alors encore je vous comprends ,vous avez tout à fait raison.En faite...

In fact I've understood the thing taht you proposed, thanx for your interest but this is not my case. Because the detail of client it isn't interesting for the department...

ok I've solved my problem that i will use an intermadiare fact table which has only IDCLI column. That will allow me to know to acces to the measures of...

Hi,

thank u so much for your kind answer, I didn't really waite as a good query ready to execute:) it is really easier than to use the cursor.

But in fact...

hi,

tnnx for your response but I tried to code like that, too.

The problem is:

my dimension table is:

date_ref ...

I'm not sure with case statement if sql server compiler reads the code line by line. Because when i change the order of the case it gives me the same...

it was exactly the respons that i was looking for. I applied it immedetly. Now my big cube can be selected in reporting serviceses as the partitions.

I've decided to create...

Thanx for your responses

I thougt to put all the measures to a big fact table but in my repport I want to visulaise that in a big cube the user...

Hi,

The thing that you must know that, if you want to get the dimensions

you must join them to fact table seperatly. But offcourse if you want diffrenet hierarchies(for...

Your structure is a little strange. Your fact table must have all the

primary key of all your dimensions and it must be relationed directly to all the dimensions that...

when i say "view" i talk abaout the new view that we create in SSAS 2008 not in sql server

merci dan

in fact thanx fr your help.

I've resolved my problem and i wanted to share with you.

my probleme was that I've created different views for different cubes.

When I created...