BusinessObjects Board

Perform DQ checks on BW queries / cubes or BO WebI reports

Hi all,

a short but crucial question for me: is it possible to access following BW or BO objects in order to retrieve data (not meta data) from them for DQ checks?

  • BW cubes
  • BW queries
  • BO Universes (UNX/BLX/DFX)
  • BO WebI reports

Thanks a lot in advance,

B.


bastula :de: (BOB member since 2008-09-22)

Yes.


Mak 1 :uk: (BOB member since 2005-01-06)

Thanks!

How?


bastula :de: (BOB member since 2008-09-22)

Well you can query the BW cube, run the Bex queries, extract the results etc.
You can run queries from both the tools used to build the universes. However I usually use the query outputs from Webi to validate the universes, compare against FHSQL results etc.

You can run the Webi queries, extract data and if good with Excel validate the report results by spread sheet manipulation.


Mak 1 :uk: (BOB member since 2005-01-06)

Hi Mak,

maybe I wasn’t clear enough: I would like to use the BO Information Steward to perform these data quality checks (although I posted in the sub forum, I should have added that).

So is it possible to connect to BW cubes, queries and BO UNX and WebI reports from Information Steward?

Thanks & regards,
B.


bastula :de: (BOB member since 2008-09-22)

I believe so.

This should help you:-
http://wiki.scn.sap.com/wiki/display/EIM/Information+Steward+FAQs


Mak 1 :uk: (BOB member since 2005-01-06)

Hi Mak,

well, we need to access the actual result data in a cube/query, not the meta data. And this is described anywhere.

Regards,
B.


bastula :de: (BOB member since 2008-09-22)

Doh! Yes, sorry, I must admit I’m unsure :expressionless: .
Are you sure that this is not something that requires Data Services to be involved to get the full use out of it?


Mak 1 :uk: (BOB member since 2005-01-06)