Logic for WEBI Reports

building reports webintelligence
1

Hi,

I have been given a 100+ reports created for banking domain .

These were created by a vendor and i need to understand the logic and business used for these reports which are created in xi .

i went through the reports and studied the filters and objects etc

but what is the best way to debug issues and how can i understand this business

please suggest the best way to understand the logic and DB and mappings for these reports .

because i cant judge if the report created by them are right or qwrong

amruta (BOB member since 2007-04-24)

2

Shouldn’t you be asking the vendor these questions?

Again the vendor should be validating the reports they deliver.

dessa :madagascar: (BOB member since 2004-01-29)

3

You should go back to the requirement specs.
In addition you could validate the SQL queries using an editor, to ensure the right data is there, in the first place.
As Dessa says the vendor should have tested, validated the results and be getting you to sign off.

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

4

the vendor has left now and the docs are available but my reporting manager wants me to debug them on the spot

i have even got warnings from him that i should be able to find solution

i generally try 2 validate the sql query with DB and see why the figures dont match .Most of time i have to call the vendor and it seems that a colum was missed etc in DB and universe.

I want to take to take control of universe and reports and understand the logic and every Detail of DB and Source jois mappings . i want to avoid dependency on vendor … he might come for handover again .

Please let me know what all things to ask him.

please suggest me some apporach based on your experiences .

amruta (BOB member since 2007-04-24)

5

As Mak 1 suggested, get all the documents in hand and give them a read to understand what is what such as business logic and all. At least you should understand requirement specification and design documents. Once you do, you should be able to get a basic idea to debug the reports. If you’re stuck somewhere, pour out on B :mrgreen: B!

Jansi :india: (BOB member since 2008-05-12)

6

Hi,

.
Just to ask, was there any document which says that the reports were tested thoroughly and then they were pushed into PROD environment?

Is there any business analyst from the business side who can validate whether the reports which were designed matches the specifications?

Omkar Paranjpe :us: (BOB member since 2006-02-13)