Hi Srinivas, if we use input CV with input parameter in CP and bex qery how can we pass the value fro bex report ? What kind of variable and processing type we need
Here you are taken current date 05-MAY-2022 , i want to See 31-Mar-2022 are some other dates. for audit report, by entering date want to see that date related stock. how to write the query for that. please help me.
There is some video missing after 17th video as direclty you are talking about calculated columns in this video and not shown to us in the earlier vidoe.Can you pls post it.
Hi, nice video. I have a problem with an input parameter with multiple values. I use this expression: in("LGORT",$$IP_LGORT$$) It works only If enter at least one value, if I leave the parameter empty I get the following error: Error: SAP DBTech JDBC: [2048]: column store error: search table error: [34023] Instantiation of calculation model failed;exception 306108: Query entries cannot be parsed. Failed to convert expression "in("LGORT",)" to QueryEntries at node Projection_2. Reason: Evaluator: syntax error in expression string;expected TK_ID,'in("LGORT",[here])' The proper solution is to use a variable in the semantics, but I need to filter this in a node because I cannot aggregate by LGORT. It will generate more than 1 row for material. I'm using a Analytic View that filter LGORT with a variable but in this new Calculated View, the variable is not called. Any suggestion? Thanks!
One question: what if I create a Input parameter in aggregation node, instead of projection node? Will the data get filtered from aggregation node only? How do I pass the filters values to projection node? Thanks
where ever you create 'Input parameter' in CV, you have access to use it in any other nodes in the entire CV. If you applied filter using an 'Input Parameter', the filtering happens at that node (Note: At run time, SAP generates one SQL for the entire CV logic, at this time if it is possible to push down your filter to base nodes, it will push your filter to the possible base node. This you can see in Vizplan only). But when we talk on a high level, we can say like, Input parameters are used to filter the data at the Node level, with this we can increase the performance and get better runtime. Happy Learning 🎓
Input parameter on Material with single value related CV used in Composite Provider and then created Bex query on top CP. Now I want Multiple single value. Please suggest how to handle this scenario. I am getting Error "InfoObject Material must be uniquely selected in the query". Please suggest
Hi How you written expression to apply Input filter on Material is important. you must use IN operator for this Input Parameter becuase it holds multiple single values. And If possible, make sure you make this filter as mandatory at report level.
Hi Srinivas, if we use input CV with input parameter in CP and bex qery how can we pass the value fro bex report ? What kind of variable and processing type we need
Great content
Thanks for the video :)
Here you are taken current date 05-MAY-2022 , i want to See 31-Mar-2022 are some other dates. for audit report, by entering date want to see that date related stock. how to write the query for that.
please help me.
There is some video missing after 17th video as direclty you are talking about calculated columns in this video and not shown to us in the earlier vidoe.Can you pls post it.
What IDE are you using?
Awesome video Srinivas. Question... Can we use Variable as Cascading Prompts in WEBI?
😂
Hi, nice video.
I have a problem with an input parameter with multiple values.
I use this expression:
in("LGORT",$$IP_LGORT$$)
It works only If enter at least one value, if I leave the parameter empty I get the following error:
Error: SAP DBTech JDBC: [2048]: column store error: search table error: [34023] Instantiation of calculation model failed;exception 306108: Query entries cannot be parsed. Failed to convert expression "in("LGORT",)" to QueryEntries at node Projection_2. Reason: Evaluator: syntax error in expression string;expected TK_ID,'in("LGORT",[here])'
The proper solution is to use a variable in the semantics, but I need to filter this in a node because I cannot aggregate by LGORT. It will generate more than 1 row for material.
I'm using a Analytic View that filter LGORT with a variable but in this new Calculated View, the variable is not called.
Any suggestion?
Thanks!
One question: what if I create a Input parameter in aggregation node, instead of projection node? Will the data get filtered from aggregation node only?
How do I pass the filters values to projection node?
Thanks
where ever you create 'Input parameter' in CV, you have access to use it in any other nodes in the entire CV. If you applied filter using an 'Input Parameter', the filtering happens at that node (Note: At run time, SAP generates one SQL for the entire CV logic, at this time if it is possible to push down your filter to base nodes, it will push your filter to the possible base node. This you can see in Vizplan only). But when we talk on a high level, we can say like, Input parameters are used to filter the data at the Node level, with this we can increase the performance and get better runtime.
Happy Learning 🎓
@@SrinivasSAP Thank you :)
@@SrinivasSAPhow can we give input parameter with a range. Can you pls shed some light on that
Input parameter on Material with single value related CV used in Composite Provider and then created Bex query on top CP. Now I want Multiple single value. Please suggest how to handle this scenario.
I am getting Error "InfoObject Material must be uniquely selected in the query".
Please suggest
Hi
How you written expression to apply Input filter on Material is important.
you must use IN operator for this Input Parameter becuase it holds multiple single values. And If possible, make sure you make this filter as mandatory at report level.