Issue with Multiprovider BEx query data not available when execute

[Former Member]

Hi Experts,

I am facing the following issue with multiprovider

"While attempting to pull some data as part of a business request from the MultiProvider in BEx, I noticed an issue . It appears that the MultiProvider is having issues with pulling data from the year 2007 ODS objects. When I attempted to run query ‘Cust Sales by machines’ in BEx for machine 4 & 5 for actual delivery date , no data is returned. When I went and check into manage of ODS data is available for the machines 4 & 5 but i am able to get data in reporting for the Year 2006 for the machines 4 & 5"

Can any one help me out to resolve the above issue

Regards

Kumar

[Former Member]

Check identification of your multiprovider; did you choos the characterestics and KF from all the infoproviders?.

Regards

[Former Member]

Hi,

Thank you for your immediate response.My ODS has ZMachine as characteristic infoobject which has values such as Machine 4 and Machine 5.0FISCALYR is a Time characteristic object which has values such as FY07,FY06.In identification ZMachine info object has been checked.

Kindly note that my ODS has data for Machine 4 and 5 for the year 2006 and 2007.

In the reporting i am able view the data for Machine 4 for the year 2006 and 2007 but the same is not coming for machine 5.

Hope i explained u clearly

Regards

Kumar