Advanced Analysis issue while connecting to SAP BW 7.4

[Former Member]

Hi Expert ,

I am facing issue while connecting Advanced Analysis with SAP BW 7.4 (HANA DB).

BW system has been migrated from Oracle DB to HANA DB .

The connection for SAP BW 7.0 (Oracle DB ) is working fine but issue while connecting the copy system in HANA DB.

Please help to resolve the issue .

Regards,

Sudheer

[Former Member · Accepted solution]

Please find the error Message :

Error 1  :Unable to open data source: BW1[Connection server] ,"ReportName XXXXX"(Internet, IMS/SO)

Error 2: Fields access using index =-1 on STRUCTURE TABlE failed

[TammyPowlas · Accepted solution]

Can you connect your BEx Analyzer to BW on HANA?  Is it the same issue?  Are you using a data source?

Which version of Analysis Office are you using?

[Former Member · Accepted solution]

Hi Tammy ,

Please find the Advanced Analysis Version :

SAP Business Object Advanced Analysis Edition for Microsoft Office

Version : 1.0.5.884

I am able to open and execute the report using BW BEx Analyzer but having issue in connecting  & executing the  BW report/datasource  using Advanced Analysis tool .

Many thanks in Advance for support  ..

Regards,

Sudheer

[TammyPowlas · Accepted solution]

1.05 - that is a version of Analysis from back in 2010 - could you try doing this with Analysis 1.4 SP10?

[Former Member · Accepted solution]

Thank you for the information .

I will try to update the Advanced Analysis Version , does it mean Advanced Analysis 1.05 is not supported by SAP BW 7.4 .

[TammyPowlas · Accepted solution]

My guess is that the first version of Analysis 1.0 is likely out of maintenance