passing a default parameter to subreport

Question

Hi,

I need to pass a default parameter to a subreport in MDX. I've a cascading parameter in the subreport but in the main report i've only one parameter. I want to pass a fixed "[All]" to the subreport (or whatever). Tried different syntax but no luck sofar.

Things i  tried:

="[All]"

="[dimension].[hierarchy].[All]"

="[dimension].[hierarchy].[aspecificmember]"

 

Hennie

Answer 1

hI,

Kindly check if the All Level is Not Renamed to any other Name.

---

Rakesh M J

Dont forget to mark it as Answered if found useful

MCTS,MCITP,MCSS

http://myspeakonbi.blogspot.com/

Answer 2

Hi Hennie,

 

Please check "[dimension].[hierarchy].[All]" you are passing is against which parameter of sub-report.

The parameter should be of same dimension and hierarchy in sub report.

 

And, also check the [All] in your cube by browsing it.

[Dimension]

   ---- [Hierarchy]

             -------- [All]

                        [Hierarchy]

 

 

Regards

Manoj

Answer 3

In addition you could check when using the below format that the subquery is not using a multiple type of parameters

this sometimes throws string value errors

="[dimension].[hierarchy].[All]"

Answer 4

thnx. I already found out that the AllMemembername was changed..Gr Hennie