Slicers ans Prompts

[tavgen]

Hello.
First i would like to say sorry for my english, as it isn't my native language
I have a problem dealing with slicers:
So I have a cube that has a Time Dimension which has 3 levels
Year
Quarter
Month
The report has Value Prompts for all 3 levels. What i need is 3 situations
1) the user selects the year and the report runs only for the selected year.
2) the user selects year then the quarter and then the month, so the report runs only for the selected month in the current quarter for the current moth.
3) the user selects year then the month, so the report runs for the selected month in the current year.

I only made so that the report has Value Prompts for all 3 levels and they are cascading prompts, so the 2nd and 3rd prompts are cascading on the 1st and 2nd level prompts respectively.

I can create a slicer for the Year prompt as:
#prompt('Year','mun','members([oTotalExpensesC1].[Time].[Time].[Year])')#
But i have problems with other slicers that would allow the 3 setuations, above.
Would some one please, give my any advice?

[siyad]

I am wondering why cant you have a tree prompt on the time dimension and adding a prompt like [time hierarcy] in ?TimeSelection?. This will possibly will give the user to select a year, or quarter or a month

[tavgen]

Thank you very much for your reply but now i am facing another problem.
What i did: i added a tree prompt that uses the parameter 'Time'.
In report i use a Data item, which filters the report on the Time, that we have selected.
This Data item looks like
item (
     filter (
          [oTotalExpensesC1].[Time].[Time];
          roleValue( '_memberCaption'; [oTotalExpensesC1].[Time].[Time] ) = ?Time? );
     0
)

This item was used in the previous report and now i dont really now how to adapt it to the tree prompt. I am now sure what function to use to do it? Did you get what i mean? Please help!
Thank you very much in advance!

[adik]

create a slicer similar to this this:
#
prompt
(
  'Month',
  'memberuniquename',
  prompt
  (
    'Quarter',
    'memberuniquename',
    prompt
    (
      'Year',
      'memberuniquename'
    )
  )
)
#

[siyad]

If you have a tree prompt on time dimension , then you need to add a detail filter like

[oTotalExpensesC1].[Time].[Time] ) = ?Time?

let us know if you have some other requirement in the report which the above doesnt fit in

[tavgen]

create a slicer similar to this this:
#
prompt
(
  'Month',
  'memberuniquename',
  prompt
  (
    'Quarter',
    'memberuniquename',
    prompt
    (
      'Year',
      'memberuniquename'
    )
  )
)
#

Adik!
Thank you very much for your reply. After adding the slicer that you have suggested the report works this way:
1)i select the year and after that i can select the quarter, and after that i can select the month and the report works as expected
2) i select a year and after that i can select the quarter, then the finish button is available, i click it an the report works as expected
but i also need another case which is:
3) i select the year and after that i can select of the quarter or the month. In case 2 month is available only after i choose the quarter.

On the prompt page i have :
1)Year prompt, which uses the parameter Year
2) quarter prompt, which uses the parameter Quarter and the  Cascade Source is Year
3) month prompt, which uses the parameter Time and the Cascade Source is Quarter.
In the query i have a following Data item
item (
     filter (
          [oTotalExpensesC1].[Time].[Time];
          roleValue( '_memberCaption'; [oTotalExpensesC1].[Time].[Time] ) = ?Time?    );
     0
)
This item helps to run the report on the selected time. Will you give me another advice please?

[adik]

you will need to provide some default values for each parameter. try something like this:
#
prompt
(
  'Month',
  'memberuniquename',
  prompt
  (
    'Quarter',
    'memberuniquename',
    prompt
    (
      'Year',
      'memberuniquename',
      year level here
    )
  )
)
#

and make your prompt optional not required

[tavgen]

you will need to provide some default values for each parameter. try something like this:
#
prompt
(
  'Month',
  'memberuniquename',
  prompt
  (
    'Quarter',
    'memberuniquename',
    prompt
    (
      'Year',
      'memberuniquename',
      year level here
    )
  )
)
#

and make your prompt optional not required

Thank you very much Adic!!!
That worked! I really appreciate your help!!!