Hello,
I would like to select only “X04” (see items codes on the right of my print screen) in the parameter filter from the Item Code. It is possible to do this directly in the Parameter Values?
Thank you in advance,
substring in the parameter value filter
My first thought is to go to the data cube, create a calculated column that extracts the first 3 characters, and you can use that column to trigger whatever you need in the metric set / dash. Would that suffice?
2 Likes
Thank you Ken! That works good for the moment.
1 Like
Awesome! I also learned that if you need this kind of thing often, it’s better to do it using the database server, i.e., create a view in the database, or write sql in your data cube in Dundas to process those things before it hits your Dundas server.
Best of luck!
3 Likes