Current Position:Home > Webi Report : Drill Functionality not working properly

Webi Report : Drill Functionality not working properly

Update:11-30Source: network consolidation
Advertisement
Hello Guru's,
I am working on Webintelligence Rich Client XI 3.1 FP 3.5.
I have created a hierarchy Country -> Region -> Location -> Customer  and Sales Amount in my universe. I exported it to CMC and Created a Webi Report. I selected Country and Sales Amount only into the output screen and clicked on DRILL button in Webi Report and it showed me a line below Country which represents the drilldown is ON now.
When i clicked on Country, it drills to Region and when i select any region, it drills to location and then to customer. The objects which is drilled that we can see in the Report filter (in the toolbar). Now, if i want to change Country or Region or Location directly (rather then click on Up, Up and Up). So, i clicked on the objects available in the report filter (in the toolbar), it doesn't show me the other contries or Region or Location while i see the same functionality in the standard Webi report (Formatted Report for Drill) given by SAP. If i drill any dimension then it comes in the Report Filter tool bar then i can see all the values for that dimension in the Report Filter and i can change it any time.
What is the difference in that filters ? Do i have to make any settings ?
Please do the needful and let me know.
Regards,
Komik Shah

The Best Answer

Advertisement
Hi,
Can anyone help us on below requirement:-
We are trying to build a BW hierarchy based  webi report. Trying to use drill features on charts.
Then using this document link in our website ,which is used on Mobiles.
The problem here is - I cannot drill up on an hierarchy using on mobile without right click.Is there any way to do do this?
Regards,
Vidhi
  • Webi Report : Drill Functionality not working properly Update:11-30

    Hello Guru's, I am working on Webintelligence Rich Client XI 3.1 FP 3.5. I have created a hierarchy Country -> Region -> Location -> Customer  and Sales Amount in my universe. I exported it to CMC and Created a Webi Report. I selected Country and

  • Syntax for passing Xcelsius parameters to Webi Report (Drill Down) Update:11-30

    Hi, I am trying to drilldown from an Xcelsius chart to a webi report by passing the prompts. And I have given the following syntax: http://<CMS SERVER>:<PORT>/OpenDocument/opendoc/openDocument.jsp?iDocID=<DOCID>&sType=wid&sRefres

  • Drilling is not working properly in Webi Report Update:10-11

    Hi Experts, I have created a webi Report using webi ritch client, in which i has linked two tables using link Element and its working fine but i want to enable the Drill Functionality on the child table only so that what ever selection is made from p

  • Drill function implemented on Measure object column in the webi report Update:10-11

    Post Author: madan kumar CA Forum: WebIntelligence Reporting Hi, I have a small issue in my project.(Maintenance Project)I created a measure object in the fact table of the existing universe and saved and exported to the repository. (Say Measure obje

  • Drill in Webi reports via Java SDK Update:11-30

    Hi! Is it possible to programatically drill up\down in Webi reports? I'm looking throught RE documentation - there are interfeces providing drill functionality (DrillInfo etc). But I can't understand how I can drill in InfoObject instance or may be I

  • How to disable drill option for one column in the WebI Report Update:11-30

    Hi, How to disable drill option in a column in WebI? When the Drill option is enabled by default all the column in the report will have that enabled, I ahve added Hierarchy in the Custom hierarhcy list in Universe. I am using BOXI3.1 WebI Reports. Bu

  • Dynamic Drill Down Column wise in Webi Report Update:11-30

    Hi All, I need to have dynamic drill down functionality in my webi report. For example I have Columns; Fiscal Year, Fiscal Quarter, Plant, No. of PO line (4 columns). Drill down on Plant level. When i click on plant a new column should be added in we

  • Webi report on OLAP Bex query -  Cost element Hierarchy not working Drill down Update:11-30

    Hello, We have a BO report on Bex query, Not on universe, we have a Hierarchy for Cost Element Group, and we are expecting the Drill down functionality for that in BO report, but it does not. Webi report on OLAP Bex query -  Cost element Hierarchy no

  • Data of measure is not seen in  webi report when drill is disabled Update:10-11

    Hi i have created a hierarchy in universe on which i drill down in webi reports the problem is that  i have drilled my report till the last level and saved it the object  on which im drilling  is set as a section in the report so i have added a measu

  • Drill by is not enabled in BO 4.0 WebI report Update:10-11

    Hi, In one of my report I have to do Drill by. But when I right click on the dimension I am able to see only Drill Down that is enabled. Drill by is not enabled. Please let me know how to enable Drill By in BO 4.0 WebI report. Thanks in advance Lavan