I did not know BusyReports free program.

I will test.

I use SQL SERVER 2008 R2 Standard Edition , it would be very useful ...

A question...

Where do i unziop executable files ???

In...

Dimension Codice_Filiale (It is like for you Dimension Stores..)

I attach dimension structure and image about Role User FullStore and Role SelectedSpecificStore

Stat_Resp_Age_Cli is dimension like Customer

Analisys is about customer named...

Hi thanks a lot for your answer ..

But nothing i cannot solve problem.

You were right to tell me my expression was wrong.

I corrected it in :

SUM([Codice_Filiale].[Codice_Filiale].[All CodiceFiliale],[Measures].[Importo Venduto])

It works but...

Hi i have tested your reply.

Unfortunately it does not work as i need.

I obtain a value too big ... i also did not understand what it is...

I created with your...

Thanks for reply.

So you tested with a ROLE that use Dimension City with the same meaning i need.

Okay now i am out of office ...i will try as sonn as...

Hi thanks for your kind reply...

I try to explain better...

I have a role for each chief of store.

In this role i set Dimension Store selecting only a store has default.

Others...

I confirm that your solution works,

So..many thanks !!!

It is simpler i could imagine...

I am not Young but not so good in MDX ...

Regards !!!

Thanks for your kind answer.

I will try as soon as possible...

I am thinking it is simpler than i'd imagine ..:-)

i WISH FOR YOU and all people of this useful blog,,,HAPPY...

Thanks i will find on http://www.codeplex.com ????

Thanks for reply.

I never thinked to that...

I will tru if it will be necessary.

Very good article indeed.

I tried to do last month alone, but i was not able.

I will try also to pass any parameteres.

Thanks again.:-)

Very good article indeed.

I tried to do last month alone, but i was not able.

I will try also to pass any parameteres.

Thanks again.:-)

Sorry you are right.

COUNTDISTINCT solution.

Thanks again.

Thanks for your kind reply.

I will try also that you wrote me.

Thanks again.

Thanks for your kind reply.

With your post i solved problem.

Thanks.