All,
I'm trying to create a filter expression based on 3 prompts that are in prompt page. I have static choice and 3 list prompts that show up on user screen based on static choice selection.
case when(prompt_static =1) then(cube_dim1 = prompt1)
when(prompt_static =2) then(cube_dim2 = prompt2)
else(cubel_dim3 = prompt3)
end
this either does not return the report at all or does not run and throws errors i have not seen so far in my career etc.
did anyone really used these kind of filters in mdx reports on transformer cube, this is 10.2.2
The first problem is that you appear to be using relational syntax on a dimensional data source. You need to use members and sets when working with dimensional data sources. This is pretty well discussed in the Report Studio user guide. See chapter 11, especially starting on page 342 (pdf page 378).
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.0/ug_cr_rptstd.pdf (http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.0/ug_cr_rptstd.pdf)
That said, you really should not use detail filters on dimensional sources, like Transformer cubes. See the Report Studio FAQ item 4 for details.
http://www.cognoise.com/index.php/topic,27563.msg88334.html#msg88334 (http://www.cognoise.com/index.php/topic,27563.msg88334.html#msg88334)