hi,
we are using xcelsius 2008.we created a parent XLF file for a year chart.we created another XLF file named child.XLF with Quarter data.i created a flash variable in child file and linked it to a cell.now i m trying to open the child file from the parent file using the url: http://ctsintcovhnbo:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=9391&sKind=Flash.&lsSyear=2007
but i m not able get the values in child SWF using this link…the link is opening but the flash variable created in child file is not taking the value…this there any ohter way…Please help us
I am having a similar issue with Flash Variables. I create a simple SWF with Xcelsius. In Xcelsius I have gone to the data connections and added a flash variable with variable format CSV. This has been linked to a single cell in the spreadsheet and the variable is called name. I then export to HTML and can view the SWF fine. Next I view the source code and can change the relevant value to any name like Chris, Bob etc with it bringing back the changes :
variable.swf
When I go to
C:\Documents and Settings\bucchr01\Desktop\variable.swf and try to call it with the variable as follows :
C:\Documents and Settings\bucchr01\Desktop\variable.wsf?Name=Ted
It fails saying it cannot find the file
I must be doing something stupid but not able to pinpoint the issue
I tried to replicate what you have done & i get the same error as you do.
I also tried to open the html [C:\Documents and Settings\bucchr01\Desktop\variable.html?Name=Ted] and pass FlashVars and it still throws the same error.
I tried to pass Flashvars within BOE using the openDocument and it worked fine:
http://servername:port/businessobjects/enterprise115/desktoplaunch/opendoc/openDocument.jsp?sDocName=FlashVars_tst&lsSName=Ted
I think we cannot pass the Flashvars to the SWF/HTML files directly in the URL(as our previous unsuccessful attempt) which are on local machines.
Hi Sweaty,
I am also looking for same thing!!!
how did you pass the flash variables in open doc function in xcelsius?
Do we need to use CELogon Token to pass the flash variables?
Can you please explain clearly.
You do not need to use CELogon Token as I believe this is created and kept in cache by BOE.
I passed flash variables by creating Xcelsius SWF with Flash Variables in from the Data Manager. When I called this SWF from opendocument I added the &lsS"Name of Range for Flash Variable" to the open document command.
What have you done so far and what problem do you have?
I have to develop a dashboard report using Crystal Xcelsius 2008 , Qaaws, Business Objects XIR2.
I have a stacked column chart in that and
For Ex.
I have Fiscal Qtr on X axis and Status in % on Y axis
I have 3 statuses in each bar like Open, Closed and Pending with 3 different colors on Y axis.
So whenever I click on one bar(Q4FY09) a new report has to open in a new window which gives details of that particular Quarter with 3 different status.
Please… help me to resolve this issue.
I have been trying for a long time.
Why not hide URL buttons behind the chart which use the openDocument command. If the new Window is opening another SWF then this SWF should be created using the FlashVariables option in Xcelsius. These variables can be bound to a cell in Excel from parent SWF. Then have a cell in Excel which concatenates the openDocument URL with $lsS"FlashVar" and the value you wish to pass such as 2009.
I am working on something similar and it is a learn as you go along process. Started playing with simple SWF passing variables to this directly and bulding from that trying to pass from Level 1 SWF to Level 2.
I have just started on working with Xcelsius. Now my Dashboard needs a filter which has type ahead feature. I did some research and we’ve decide that we’ll have to create a JSP page and call the dashboard from there by passing the selected value in filter to Xcelsius. Can you tell me how can we do this? How to pass parameters from JSP to Xcelsius, inturn it runs a query which will populate my charts in the dashboard.
(BOB member since 2007-01-10)
(BOB member since 2007-01-26)
