Discover your community to learn, get support, and discuss on different topics within data management and analytics.
This is your platform to ask questions, post answers and share your experience with other customers and experts from SAP.
I found very interesting and helpful the publication by @Oliver Huth :
@Oliver Huth, Useful and interesting read..! @Leon_Reznick, Thanks for sharing..!
Thanks for sharing Leon, the article was interesting to me too. 😀
Please help on my below queries in data modeling -
1) Is it possible to pass input parameter for dynamic currency conversion?
2) Can I consume Composite provider (BW/4HANA) directly in DWC for further modeling?
3) Can I consume calculation view (built in Native HANA) ?
4) Is there any document which explains all the modeling features in DWC?
Hi @Leon_Reznick -
I have a requirement to do calculations and I am not able to implement the nested if/case statements like
I need to check if RBSTAT= C or D then value should be Park OR if the RBSTAT= E then value should be Held.
I can do for 1 condition but not able to do for multiple conditions-
Please help to suggest
@pulkit25 The syntax for nested CASE should be :
CASE WHEN p1 THEN e1 WHEN p2 THEN e2 ELSE e3 END see https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.04/en-US/20a4389775191014b5a6bf2ccc0df2ed.html?q=CASE%20WHEN#loio20a4389775191014b5a6bf2ccc0df2ed___fsql_expressions_1sql_expressions_case_expressions
Thanks @Leon_Reznick, I figured but not sure why the IF statement is no more supported as we have in Calculation View.
Also, may I know if you have any idea how can I use BW extractor in DWC? I meant if I want to use 2lis BW data source directly in DWC, is it possible?
@pulkit25 I don't believe that 2lis (V3 type) extractors can support replication. All other BW extractors should be available via ABAP connection.
Hi @Leon_Reznick - I tried checking other BW extractors as well like any Master data extractors buy could get any.
Please let me know when you get a chance to check at your end.
I am not able to user greater than operator. Below snapshot for reference -
Result is not coming proper and every time I am getting result as 2. May I know what is wrong here?