Using Change parameter passing value for Delimited list in Report books is not working.

[Gayathri]

I have Delimited list parameter for scale in Cube views, when added the Cube views to Books and given the value to parameter using change parameters option but it's still prompting for it when I ran the book.

Any suggestions, without updating the Cube views and get with Books only.

[Thomas_Bennett]

The syntax of book functions is quite confusing. Id check that. Otherwise You can technically run your parameter in a loop, however, nest an if statement within the loop and only allow the selection you want in your scaling parameter to pass. Ive done this on one of my books (out of laziness adapting it from another rather than building a new book!) And it gets round having to set up unique CVs without the Parameters.

Good luck!  

[Gayathri]

Thanks for your response, Thomas.

I have tried it, still it is prompting for selection.

Thanks,

Gayathri.N

[Thomas_Bennett]

Ive always wrapped the loop variables in square brackets  try [|Loop1Variable|] = [In Millions]

[Gayathri]

Thomas, after using square brackets also it is prompting for selection. 

[Thomas_Bennett]

One thing to check is that Loop1variable is returning "In Millions". I.e. you have Loop1variable and Loop1displayvariable which relate to the two rows in the parameter. Easy to get caught out by this on a delimited list, I did!

[Gayathri]

Thanks Thomas, could you please provide the screenshot of if statement in the report book if possible.

[Thomas_Bennett]

here is an example of one of my working books:

Parameter:

Loop:

Change param:

If statement, It was shorter and more intuitive using Loop1displayvariable :

and the book object, note I dont have any required input parameters. This might be your issue as I think this overrides selections within the loop:

Finally the Tabs of the output report as proof :D. This book was quite complex as its three nested loops for currency, column set and V#:

[Gayathri]

Thanks for sharing it, Thomas.