Load data with BODS from Query as an external views

[aczeitner]

Hey Specs !

I have a composite provider which sits on a hana calculation view.

When I preview the calculation view I see data for year 2022.

I had to create a query on the composite and from that I have generated an external view, cause I want to load data with BODS.

However When I preview this external view or try to load data from it it does not shows any error but the result is 0 rows.

I have input parameter in the calculation view for calendar year. (and I cannot remove it )

Without no real error just that i see 0 result what can be the problem ?

What can be the best approach ?
I am not sure if it is security issue or do i need to do something specific to get result from the external view.

Thanks Andras

[vishalakshmi]

Please refer to the below information:

https://blogs.sap.com/2018/08/08/examples-using-input-parameters-with-calculation-views/

Thanks,

Lakshmi.

[vishalakshmi]

Hello Czeitner,

SELECT * FROM <schema_name>.<external_view_name> WHERE calendar_year = ?;

The "?" represents a placeholder for the input parameter value.

Pass parameter value from Bods, verify parameter mappings in bods.

Thanks,

Lakshmi.

[aczeitner]

I think this syntax is for adding input parameters of the query, but I have problem with the input parameter of the original calculation view that the query inherited from

[vishalakshmi]

Verify that the user executing the external view has been granted the appropriate privileges on the external view itself. In SAP HANA, you should grant SELECT privileges on the external view to the user or role that needs access. For example: SQL query

GRANT SELECT ON <schema_name>.<external_view_name> TO <user_or_role>;

Make sure that the user or role has SELECT privileges on all the underlying objects (tables, views, etc.) that the external view depends on. The permissions must be granted for both the schema containing the external view and the schema containing the underlying objects.

Composite Provider Permissions should be granted for both the schema of the composite provider and the schema of the calculation views.

Check that the user has the SELECT privilege at the schema level where the external view is located. Even if the user has object-level privileges, a lack of schema-level privileges can prevent access.

Regarding logs check, you need to check SAP HANA Trace logs, SAP BODS job logs, Application logsBy doing this you should be able to pinpoint the source of the issue.Thanks,Lakshmi.

[aczeitner]

Yeah I have all that. the issue seems to be with the input parameter from the calculation view.
It works on the calculation view level in data preview.

It works on the composite provider's external view ( I can see data) with placeholder).
But when I open the query as the external view I do not know how to generate sql that shows data 😕

[vishalakshmi]

Hello Czeitner,

• Ensure that you've provided valid input parameter values for the calendar year when previewing the external view or loading data. The external view may be dependent on the input parameter to retrieve data, and if you're not passing a valid value, it might return 0 rows.
• Verify that there is data available for the specific calendar year you're querying in your external view. It's possible that there are no data records for the year 2022, or there might be a discrepancy in data between the time you previewed the calculation view and when you're working with the external view.
• Check your user's permissions and roles. Ensure that the user executing the external view has the necessary permissions to access the data in both the calculation view and the external view. Lack of proper authorization can lead to a situation where you can preview the calculation view but not access the data through the external view.
• If your calculation view relies on view parameters, ensure that these parameters are also configured correctly in the external view
• Check datasource configuration.
• Check logs if you see any errors.

Thanks,

Lakshmi.

[aczeitner]

"Ensure that the user executing the external view has the necessary permissions to access the data in both the calculation view and the external view. Lack of proper authorization can lead to a situation where you can preview the calculation view but not access the data through the external view."

Could you please advise ? I can run the query itself I only lack the abbility to run the external view created from the query

"Check logs if you see any errors."

Could you please advise ?