WEBI data is missing

[Former Member]

Good day everyone:

I need your help with 2 webi issues, the situations are the following.

Situation 1:

I have a report that contain: Year, month, region, adjuster and Average Valuation

If i run the query filtering the report by adjuster=adjuster1 only shows information of 2008 but if i run the query filtering by adjuster=adjuster1 and year=2010 or year=2009 the reports shows the information of the year filtered. It means that there is information for the 3 years but for some reason webi doesn't display it correctly

Can somebody tell me why is that or how i can fix it???

NOTE.- this happened only when in the query there is the dimension adjuster, if i remove it form the list of objects the report shows the 3 years

Situation 2: (similar to the first one)

I have the same report that contain: Year, month, region, adjuster and Average Valuation

If i run the query filtering the report by adjuster=adjuster1 and year=2010 the reports shows only from january to august, the information of the year filtered. But if If i run the query filtering the report by adjuster=adjuster1, year=2010 and month=september or month=october the reports shows the information of those months. It means (again) that there is information for every months but for some reason webi doesn't display it correctly.

NOTE.- this happened only with a few adjusters

My source data is a OLAP Cube in Analisys Services 2000

Im using BOE XIR3 SP2.

I really hope you can help me i dont know if im doing something wrong or i have to configure something something else.

Regards!!

[Former Member]

Is it the same behavior at OLAP cube level can you test it??

I think, you can't see SQL/MDX query generated by BO, correct??

Thank You!!

[Former Member]

Is it the same behavior at OLAP cube level can you test it??

No, the OLAP cube shows the information correctly, thats how i saw the error.

I think, you can't see SQL/MDX query generated by BO, correct??

Thats right when use OLAP cubes webi doesnt allow to see the SQL/MDX query

[Former Member]

In that case, we have to visually analyse Cube definition.

As a work around, Can you filter data how you want at Report insteadof filtering at Query level.

Here...,,

Do you have Key(Detail object) also along with Dimension object ?? YES, then drag that Key detail object also into query.

I worked on SAP OLAP cubes, exactly same issue I faced many times, to solve it I dragged L01 Key detail objects also in query and not for Reporting.

To be honest, i'm not sure about SQL Cube structure and objects definitions.

Hope you this logic works for you.

Thank You!!

[Former Member]

Well im working with Analisys Services OLAP cube and that cube doesn´t have details of the dimensions the structure of the universe (the universe is based on the OLAB Cube) is the following:

Period

-- Year

-- Month

-- Day

Regional

-- Region

-- Adjuster

Measures

-- Valuation

-- Cost_Valuation

-- Average_Valuation

I drag to the Result Objects Pane: Year, Month, Adjuster and Valuation

and I drag to the Query Filter pane: Adjuster=Adjuster1

When i clic on run query the result is

2010 || Jan || Adjuster 1 || 220

2010 || Feb || Adjuster 1 || 420

2010 || Mar || Adjuster 1 || 420

...

2010 || Aug || Adjuster 1 || 250

But if i drag to the Result Objects Pane: Year, Month, Adjuster and Valuation

and I drag to the Query Filter pane: Adjuster and month= Oct

When i clic on run query the result is

2010 || Oct ||Region 1|| Adjuster 1 || 250

And i can't filter the data because it is a dinamic report and the final user will need all the information.

And im 95% sure that the cube's structure is correct because when i see the information in analisys services even in voyager the information is displayed correctly but any way i'll check it

Any other idea???

Edited by: Elio Javier Guzman Hernandez on Oct 9, 2010 12:19 AM

[Former Member]

Hey...,

Don't drag or filter any objects in Query filters pane.

1. Drag objects what you want to see into Result objects and Run query. And Fiter data at report to show only Adjuster1.

2. Drag Region also along with Adjuster1 to result objects and see how it goes. (Use with Query filters and Without )

Hope it helps you to get all data.

Thank You!!

[Former Member]

Goog day!!!

Sorry for the delay, the issue has been solved thank you, the information that you gave me was useful.