How to filter results for ''All Periods''?

Hi, all,

How could we filter the results to exclude 'All Periods'? E.g. I would like to see sales amount for year of 2001,2002. etc, and I dont want to see the results retured for 'All Periods', thus how could we achieve this?

Thanks.

With best regards,

Yours sincerely,

Hi, experts,

Anyone of you know the answer? Thanks and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

|||

Hello Helen! I am not sure about your problem but this is what you get if you put years on rows or columns in Proclarity Professional. You do not have to filter on years in order to se the years that you would like.

Simply put the years you would like on rows or columns.

If you slice on years,that is choose one or several members in a dimension as a background dimension i Proclarity,

you can pick the year that you are interested in.

Can you tell more about what you are interested in?

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thank you very much for that.

What I was wondering is to filter the 'All Periods' in the results returned by SSMS (Management Studio) against the MDX query launched there.

Hope it is clear for your help and advices.

With best regards,

Yours sincerely,

|||

Hello Helen! If you run this MDX on the Adventure Works cube:

Code Snippet

Select {[Date].[Calendar].[Calendar Year].Members} On Columns,

[Product].[Product Categories].[Category].Members On Rows

From [Adventure Works]

Where ([Measures].[Internet Sales Amount]);

Is this what you are looking for?

Kind Regards

Thomas Ivarsson

|||

Hi, Thomas,

Thank you for your help. Yes, that's what I am looking for. And how can we add subtotals for each column and each row to the results returned?

Thanks and I am looking forward to hearing from you.

With best regards,

Yours sincerely,

|||

Hello Helen. In ProClarity Professional 6.3 you have an MDX-editor. I think it is under the meny-view.

Create subtotals in ProClarity and copy & paste that code to Management Studio.

That is a good start.

Regards

Thomas Ivarsson

|||

Hi,Thomas,

Thanks a lot and obviously this is an effective way of doing it.

With best regards,

Yours sincerely,