Skip to Content
0
Former Member
Oct 08, 2010 at 05:25 PM

WEBI data is missing

38 Views

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!!