Webi Drill on a dimension using substring

[richiew03]

Hi,

I have the webi drill functionality working on dimensions, however I would like to use substring on one of the dimensions, when I do this I loose the ability to drill. Anyone have a work around?

The universe is a BEX query so I believe I can't use substring or the "RIGHT" command. Additionally the field is fiscal period I want to substring,

Thanks,

R

[arijit_das · Accepted solution]

When you are using some formula, you will loose the ability to drill. What you can do is to create an object in the universe itself and use that in the hierarchy. But In case of OLAP universe, I don't think you can use any function to get the substring. So alternatively, you can have a separate detail webi report with similar structure and pass the drilled dimension value from the summary report to the detail report's filter.

[richiew03 · Accepted solution]

PAS, quite right, it would seem the only piton would be to manipulate the value in the universe but this is not possible when the source is a BEx query...

instead I will have to make to with sub optimal descriptions, thanks.

R