Current Position:Home > Data for a node in Hierarchy not displayed in BEx report.

Data for a node in Hierarchy not displayed in BEx report.

Update:10-11Source: network consolidation
Advertisement
I have a time dependent hierarchy on 0ORGUNIT. There is a report which displays employee wise, ORGUNIT wise data. This report is based on a Infocube which also has 0ORGUNIT updated in it as a charecteristic.
When i view the contents of the cube for a particular orgunit (5000397), employee (5980) for a particular time range (01.01.2011 - 16.01.2011), it gives me some data. However when i execute a report in BEx (7.0) with the same restrictions; it shows 'No applicable data found'.
In the query designer I have corectly assigned the hierarchy properties to 0ORGUNIT with the hierarchy name, version and date (last date of the user entered time range). Also the hierarchy has been uploaded with the latest data i.e. for orgunit 50000397 there is an entry for the period: 01.09.2009 - 31.12.9999.
Can you please suggest.

The Best Answer

Advertisement
Can you check and make sure..that there are no other Global filters in the Query Design..
Regards,
Vikram
  • Data for a node in Hierarchy not displayed in BEx report. Update:10-11

    I have a time dependent hierarchy on 0ORGUNIT. There is a report which displays employee wise, ORGUNIT wise data. This report is based on a Infocube which also has 0ORGUNIT updated in it as a charecteristic. When i view the contents of the cube for a

  • Is it possible to Display BW Bex report iviews in Tabbed Interface? Update:10-11

    Hi,   Is their a way to display BW BEx Report Iviews in Tabbed Interface?   My requirement is to show four BEx Reports using 4 tabs on a page. Can we achieve this functionality in portal? If yes can some one guide me how to proceed? Regards Sai Krish

  • Concatenation of Data from 4 infoobjects into a single cell in Bex Report Update:10-11

    Hi, I have loaded ODS with the description data. The source system for loading the ODS is the flat file. The ODS data should be a replica of the flat file. In the flat file, there is a description field corresponding to a particular ID. This Descript

  • KF value is not Displayed in BEx Report ..where as cube, mpro end ok..!! Update:10-11

    Hello Experts, I ran a bex report. In that report KF some NetsSalesValue has not displayed in the BI Report for all the Sales Organiations where as other KFs has displayed the value for all the Sales Organizations. For that i checked my end. BI repor

  • Data load from BPC into BI 7 cubes for Bex reporting Update:11-30

    Hi, Can we pull BPC planning data into the BI cubes so that Bex reports can be created for combined data from BPC cubes and BI cubes? Also can we create Bex reports on BPC cubes just like we create for BI reporting cubes? Let me also give an example

  • Open orders display in BEX report based on Key date Update:10-11

    Hello All, I have a requirement: We have an existing report which needs to have input selection as Key Date. The report should display the Open orders based on the key date mentioned. For Eg: if an item A was Opened on 20th Sept, 2010 and now CLEARED

  • Re : Issue with the column display in Bex reports Update:10-11

    Hello Gurus, I have an issue with the reports in Bex, this is a bit confusing scenario I would try to explain in more details. A query was already built for monthly Report in Sales and Billing for which the variable were  Calender month/year range 1

  • Currency Display in BEx Report Update:10-11

    Hi, When I am executing a BEx Query with Regional Language options on the OS as English ( United Kingdom ), I am seeing the values in Number format ex : 98766EUR but when I change the Regional Language Options on the OS as German ( Deutshland ) I am

  • Bex report doesn't display full text information...... Update:10-11

    Hi Experts, My bex report is not displaying full text information. I have set that particular infoobject length as 40 and also have selected long text and Long Description in Bex Tab of the InfoObject. In my DSO the data is available in complete leng

  • I Need to change Date Format in BEx report Update:11-30

    Hi Experts, i Need display with required values with following symbols in BEx report # and Date format change as per client requirement. Without any VB Code. Let me know solution for this. By ANRMy actual requirement, by default date format display i