I’m having hard times trying to bind BW Queries prompts to spreadsheet cells inside Xcelsius.
I have BW queries feeding WebIntelligence reports using universe. These WebIntelligence reports feeds one xcelsius dashboard. These webi reports have optional prompts (more than a dozen) coming from BW queries which I have to bind to Xcelsius spreedsheets cells, when I try to do that I receive an timed out error message. I’m guessing the problem it’s the size of list of values coming from BW queries. I already tried to use the Delegated Search option in universe but no success. What’s happening? Someone has any ideas?
I have the same problem but I’m able to bind the prompt. But when I look at the prompt list, it shows the Object name and the object tech name and the object key. And I think because the neam is too long, it could not pass the value. (Error: WIS 10901). Here is sample from the prompt list - “Akshabulak [ZBOPFIDGU__ZBOPDIDID].[03415]”
As you can see, it shows the "Text [Tech Name] and [Key]. And it couldn’t pass the parameter from xcelsius. I would have like Bex prompt to only show ‘Key’. Does anyone have any idea or experience?
I have never worked with Bex Query Analyzer but WIS 10901 is database error here’s an excerpt from the guide;
Cause
The database that provides the data to this document has generated an
error. Details about the error are provided in the section of the message
indicated by the field code: {error_db}.
Action
Contact your BusinessObjects administrator with the error message
information or consult the documentation provided by the supplier of the
database
I solved my problem. I used a web app debugger (fiddler) and checked to messages being sent from my machine to the BO server through the LO connections i had and then I figured out what variable I was sending wrong. After all I have to send [0FISCPER].[Date Key]
I recommend the use of this tool given that LO connections are kind of a black box…
I have a webi report inserted in LiveOffice which need to be connected to Dashboards.I have few webi prompts(coming from Bex). These prompts have been binded to some excel cell in LiveOffice. But the thing is when i bind the value it is coming like below:
'Western Europe [CECBMU].[RWEU]
Here CECBMU is the tech name of my Region infoobject in BW and RWEU is the key for this. Is it the normal behaviour in LiveOffice?
If this is the case, how can i use this binded cell as Trigger Cell in Dashboards because i need to show list of Region values in Combobox to the user as normal like:
Western Europe
Latin America
India
Middle East
Since LiveOffice accepts the prompts only in the above mentioned syntax 'Text [tech.name].[key] , how to bind the user response to the prompts of LiveOffice. Should i show in combobox as per the syntax which user doesnt like ?
The list of values that you show the user in the dashbaord doest have to be the same values that the liveoffice connection accept. By saying this I mean that you can have two columns in your embedded excel: one with the description of the region and the column next to it with the technical name that your live office connection accept for refreshing. Then, bind the values of the first column with the labels of the combobox and configure the insertion type by row, so when the user selects a label the technical name gets moved to the bind cell of the liveoffice connection.
(BOB member since 2003-05-29)
(BOB member since 2009-08-21)
(BOB member since 2009-10-15)