Issue :
A dashboard prompt is to be created on a certain column (ex - Payment Description). Not all the values it should display. And that it should display only those values where Payment Key is equal to 0 or -1 or -2. But note that here the Payment Key is NOT exposed to presentation layer. So how can we create a prompt ?
Answer : Use SELECT_BUSINESS_MODEL clause.
Look at BMM and Presentation layer.
Payment key is not available in presentation layer.
Please carefully look at the syntax of SELECT_BUSINESS_MODEL clause.
SELECT_BUSINESS_MODEL
"<<Column name in BMM layer>>"
FROM
"<<Subject Area Name in BMM layer>>"."<<Table Name in BMM layer>>"
WHERE
"<<Column name in BMM layer>>" in ('0','-1','2')
SELECT_BUSINESS_MODEL
"Method Of Payment Desc"
FROM
"Enterprise - Billing Operations"."Dim - Method of Payment Previous"
where
"Method Of Payment Key" in ('-2','-1','0')
Look at the result
If anyone faces such type of issue, hopefully this blog post might prove useful.
Thanks.
No comments:
Post a Comment