Sitemap

Amicuk Programming Answers

Expanded hierarchies in workbook...

-0001-11-30   Views:0

Advertisement

Hi All, We are getting a weird problem when we are refreshing a query in workbook When data is refreshed, the values pull into the hierarchy top level, but not the detail level. After expanding and collapsing the hierarchy node, the values is then di

Hi All,
We are getting a weird problem when we are refreshing a query in workbook
When data is refreshed, the values pull into the hierarchy top level, but not the detail level. After expanding and collapsing the hierarchy node, the values is then displayed.
This is kind of confusing!!!!
Any ideas will be really appreciated !!!
Thanks

The replay answer
Advertisement
Hi........
Hierarchy Active
You use this function to switch display hierarchies on and off.
Hierarchy Node Expanded
Select Hierarchy Node Expanded if you want to expand a hierarchy node. If you want to collapse the hierarchy node, deselect the indicator. You can also expand or collapse the hierarchy node by choosing the hierarchy icon.
Expand Hierarchy :
Choose Expand Hierarchy ® Level <1> if you want to display more levels of the hierarchy. You can also expand the hierarchy by choosing the hierarchy icon. For more information
Also check this link :
http://help.sap.com/saphelp_nw70/helpdata/en/f1/0a5543e09411d2acb90000e829fbfe/content.htm
It may help you........
Regards,
Debjani......

Go to See the other 6 answers

Expanded hierarchies in workbook...

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, We are getting a weird problem when we are refreshing a query in workbook When data is refreshed, the values pull into the hierarchy top level, but not the detail level. After expanding and collapsing the hierarchy node, the values is then di[More]

WorkBook Formatting.

Category:DefaultRelease time:2015-10-11Views:130

Hello All, Can i get parent child relation of hierarchies in Workbook if i need to do further formatting of hierarchies in Workbook. If yes how where can i get these relationship. Thanks in advance,Hello Gill, I have to give option to the user to dip[More]

EVGTS to get data from multi-applications in a workbook of multi-worksheet?

Category:DefaultRelease time:2015-10-11Views:130

Dear all: Situation I am trying to build a financial report that consists of: 1. Balance Sheet (Finance App) 2. Profit and Loss (Finance App) 3. Sales Analysis (Sales App) 4. Inventory Flow (Sales App) 5. Expense Report (Finance App) Basically, I nee[More]

OBIEE 11g - issue when export hierarchy to a csv

Category:DefaultRelease time:2015-10-11Views:130

Hello, I have an issue when I try to export to a csv file a report containing a Logical Dimension field, when I export just the first level of hierarchy is exported and not all the records. When I export to another format (such as excel) all the reco[More]

Performance problem to retrieve the report

Category:DefaultRelease time:2015-10-11Views:130

hi gurus i am working in BW support, i got a issue regarding reports. query  taking to much time to retrieve the report, and the same probs arise when u try to drill down in report. can anyone plz give me a solution to solve my problem. thanks in adv[More]

OBIEE 11g - issue when export to a csv file

Category:DefaultRelease time:2015-10-11Views:130

Hello, I have an issue when I try to export to a csv file a report having numeric feild, when I export and open the file in notepad the trailing zeros to the right of decimal points do not show up. When export to another formats (such as excel, pdf)[More]

Regarding Reports performance

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Now i am working in Production system. How can i check the performance for reports. How can i find the report performance is low/high? Please let me know the details. Thanks Vasu.Hi Vasu, Use the search on the word  "performance", you wi[More]

Global cache

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts I want to create Global Cache on a Query to improve the performance of the Query.In RSRT we have the options of Read Mode          A Query to read all data at once          X Query to read data during navigation          H Quert to read wh[More]

Query Read mode

Category:DefaultRelease time:-0001-11-30Views:130

HI Experts,       What is QueryReadMode?  In which Scenario we have to use QueryReadMode? 1.In which situation we have to create Aggregates and how do u  know  weather the cube has Aggregates or not? 2.In which situation we have to create Indexes and[More]

Query read mode-Cache mode

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Can u explain me the functionalities of the options: A-Query to read all data at once X-Query to read data during navigation H-Query to read when u navigate or expand hierarchies I am not clear of the diff. bet. the X,H options.... <b>Cache Mode[More]

BPC v5 and evcom

Category:DefaultRelease time:-0001-11-30Views:130

Hello all, Hoping you can help..... I have recently completed an implementation of a budgeting/forecasting solution in BPC v5 and have a couple of recurring issues. As this is my first implementation using SAP BPC these may simply be down to inexperi[More]

Hot
Hi, I am getting the following error while testing the Webform "ref: 10OZcTRWdS2gJf9A1t0bQ, AccessControlViolation" An error has occurred. The form does not exist. Please re-enter the web address as the link may be misspelled. [ref: 10OZcTRWdS2g [More]
YOU CAN HAVE A MACBOOK PRO THAT ISN'T SCORCHING HOT!! (note that this will NOT fix any whine or moo; they are unrelated problems) Here's how. My Mother's Macbook Pro (Or Cookbook, if you will) Arrived a week ago today. I played around with it to make [More]
Hi, while an item is dropped as part of a drag and drop operation, I would like to know if the user has pressed any keys. I use a TransferHandler for managing the d&d and this works fine with the system dependent modifier keys for move, copy and link [More]
I am having issues installing sccm 2012 on a remote sql 2008 r2 sp2 server on a seperate instance. I get the error "The network path was not found"   if i point it at the primary instance it will let me continue but i cannot install sccm into th [More]
Hi, I deal with a daily stock infocube and I would like to set a flag when the warehouse doesn't work (on holiday). to do this, I would like to use the factory calendar (TFACS), and I have 2 questions: 1) How to maintain the TFACS table into SAP BI ? [More]
I have a 3725 with 2 vic2-4fxo cards configured as H.323 in ccm 4.0.2a. Currently I have to configure 8 pots dial peers to point to each fxo port for outbound call. I would like to find out if there is a way set up like a trunk group for fxo that way [More]
Hello, Is there a way to display customer number/Name under the Assignment column in transaction FBL3N? NicholasHello Nicholas, Please check message below. I explained how can you add an additional fields to FBL*N reports. Re: Vendor & Customers in F [More]
The majority of my music collection is Greek songs and it'ss a real shame that Creative does NOT have language support for Greek. I tried entering a song in Greek letters since I have dual language support on my Windows XP. When I look at the Media S [More]
Hello, I am having a problem where some of my pages that I add to the navigation model are not displaying in my application at run-time. See below for source code. The allresources.jspx page is not displaying at run time and I don't know why. My defa [More]
how can i turn off/disable the tomcat's auto-debug log? which is located in catalina.out. i have try to set the debug="0" in the server.xml in order to turn it off but can't. is it have any other way to turn it off? e.g DEBUG - NSPush (32) DEBUG [More]