cancel
Showing results for 
Search instead for 
Did you mean: 

Reporting ADK archived files in BI

Former Member
0 Kudos

Does anyone know a way to build a query on archive files, archived in BI using the SAP ADK standard tools?

We don't want to load back the data that we archived with transaction SARA.

So is there a way of using archive files as DataSources to build VirtualCubes on?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Create a generic datasource as you would normally do in the how to guide - and just call that via a virtual cube instead of loading the data

Former Member
0 Kudos

Hello Simon,

direct evaluation doesn't work as the archived files are compressed and encoded.

So one way could be reading the archive by sara standard report and using the output list as DataSource.

Former Member
0 Kudos

oops - sorry

We are plannign to actually do this and use a FM to call the archive objects from the raw table within the generic extractor

ie

call function 'ARCHIVE_OPEN_FOR_READ'

call function 'ARCHIVE_GET_NEXT_OBJECT'

call function 'ARCHIVE_GET_TABLE'

It's on my hit list to do in the next few months