cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to create Open ODS view to access virtual tables through SDA in BW 7.5

Hi,

I am trying to create Open ODS view while using an option “Virtual table using SAP HANA Smart Data Access”. After selecting this option, system should enable two new options which is “Existing Source System” and “Remote Source”.

But somehow these two options aren't available after selecting “Virtual table using SAP HANA Smart Data Access” & so the "Next" option to proceed further as well is disabled.

I need to consume SAP Hana views in BW from a remote Hana system .

HANA studio version 2.3.6. Attached is the screen shot for your reference. Image 1 is expected output and Image 2 is the current result.

Is it due to some authorization issue or any system issue?

Regards

Sandeep

Accepted Solutions (0)

Answers (4)

Answers (4)

Hi Nora,

Unfortunately it cannot be something related to Support Package as mentioned in the SAP Note 2362813 - BW with HANA SDA/SDI: No remote owners/schemas displayed in the creation wizard or system version, since the option to select the remote source is available in the Test & Production system but somehow not in the development system.


Regards

Sandeep

0 Kudos

Hi,

I just now tried to replicate the above issue and could figure out that the view was restricted. What I mean is detailed in below steps:

1. Open HANA studio.

2. Create new Open ODS View

3. First Image is of restricted view

4. Try to expand the view either by expanding the entry screen from bottom or maximise the view.

Regards,
Shashank

ABner
Participant
0 Kudos

Nora,

We have the same issue as well, we are on 7.50 SP10 and using SDI.

It looks like Open ODS views only support SDA, not SDI? We had to move from SDA to SDI when upgrading to HANA 2.0 as SQL server was no longer supported under SDA. But, Open ODS Views do not give this option.

Please review, thanks!

nora_roch
Employee
Employee
0 Kudos

Hi Sandeep,

I guess, the BW modeling tools should be up to date on clients side and also it depends on your backend release and support package what options are offered in the frontend dialogs.

2362813 - BW with HANA SDA/SDI: No remote owners/schemas displayed in the creation wizard

2378038 - Open ODS View: Support of Smart Data Integration

Cheers,

Nora