FreeHand SQL query with input parameters

[jlopezm]

Good morning SAP Analytics Cloud and Datasphere experts.

I recently created a successful OData connection from a view with Datasphere parameters to use the data in an SAP Analytics Cloud Planning model.

The problem I have is that I want to select the parameters from a FreeHand query when creating the model and I get different errors.

I am testing several syntaxes:

CV_MOV_CCEE_RD_WP(P_MANDT='100',P_DATE_FROM=1980-01-01,P_DATE_TO=1980-01-01)/Set

And I get this error:

If I use this syntax

CV_MOV_CCEE_RD_WP/CV_MOV_CCEE_RD_WP(P_MANDT='100',P_DATE_FROM=1980-01-01,P_DATE_TO=1980-01-01)/Set

I get an error like this:

When I use this syntax:

CV_MOV_CCEE_RD_WP(P_MANDT='100',P_DATE_FROM=1980-01-01,P_DATE_TO=1980-01-01)

I get this error:

So I understand that the syntax here is incorrect.

I have tried ending the statement with /Results but it doesn't work either.

I have consulted other questions and documentation such as these:

• https://community.sap.com/t5/technology-q-a/sac-how-to-use-odata-v4-with-parameters-exposed-from-a-s...
• https://community.sap.com/t5/technology-q-a/sap-sac-free-hand-query/qaq-p/12622748
• https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361384392.html

But I have not been able to find a solution

What would I have to do to be able to do the freehand query for views with input parameters coming from Datasphere over OData connections?

Thank you very much!

[LavanyaJ]

Hi, Were you able to come up with Freehand Query which worked? And did you add parameter in OData connection in SAC and did you set default value for parameter in Datasphere analytic model?

[XaviPolo]

If the object is a VIEW then try with:

SELECT * FROM CV_MOV_CCEE_RD_WP( 
	PLACEHOLDER.P_MANDT=>'100', 
	PLACEHOLDER.P_DATE_FROM=>'1980-01-01', 
	PLACEHOLDER.P_DATE_TO=>'1980-01-01' 
)

Regards,

[TuncayKaraca]

@XaviPolo I just noticed another good point in your example: the parameter values should be in single quotes.

[JefB]

I believe SAC is not able yet to fully consume Odata parameters, hence you see this "Basic CDI Support" item on the product roadmap as 'future vision':

https://roadmaps.sap.com/board?PRODUCT=67838200100800006884&q=odata&range=CURRENT-LAST#;INNO=000D3AB... 

[TuncayKaraca]

Hi @jlopezm,

That's a good question! I'm inclined to think that parameters are not supported in SAC for SAP Datasphere OData connections. Although it seems that Freehand Query is a solution for CDS views with parameters on OData connections. Refer to 2936924 - Input Parameter on CDS Views does not work via Query Panel from SAP Analytics Cloud (SAC)

Have you tried? 

CV_MOV_CCEE_RD_WP(P_MANDT='100',P_DATE_FROM=1980-01-01,P_DATE_TO=1980-01-01)/Results

Please note that parameter values are case sensitive, if I'm not mistaken.

Thanks,
Tuncay