Thanks for the reply, yes we have checked those and its all configured correctly. other dashboards works fine and this only one dashboard has that kind of behaviour.
We have faced similar issues, on my current site, some dashboards working, some not.
It appears, to me, that some controls on the dashboard can cause Flash / browser / active X issues.
How big are the dashboards?
Have you tried different machines / browsers to see whther you can get this working?
Do you have the correct permissions, or, does it not work for all your users?
as for the dashboard, nothing fancy we included. its only a scorecard and other basic stuff. some dashboard (which is more complicated than that with the issue) works fine.
In addition, seems that every machine on our client experience that behavior (they were the first to raise the issue to us)
We found that one of our dashboards works on one machine, fails with another with, seemingly, identical config.
Works with Firefox and Opera on the failing machine and so it goes on
Thanks for the link. as for the security issue, I believe we have all set it correctly since other slides works fine.
Maybe theres a bug of something si wrong with my sourcefile. cant tell though but are there any tools in the net that can optimize flash files for Xcelsius?
Starting with the most complex component, delete them one at a time, and republish between deletions. Sooner or later you will find your bad component. Delete it, and rebuild the component.
@Mak - sorry for the confusion, we are just used to call Xcelsius dashboards “slides”. btw, we are using web service directly connected to Bex Queries via Function Module WS and publish it in InfoView.
seems that the last option would be redoing the whole slide once again. but if there are any other options that we can try we would deeply appreciate it.
Thanks for the advise, yes, sometimes it runs sometimes it doesnt. its really annoying knowing that this is the only dashboard that behaves like that.
im now weighing down the time it would take to filter the components and re-do the slides. but I’m still hopefull that there would be an easier way to get this work done.
will get back to you guys if I found anything. in the meantime, I’ll get some cup of good brewed coffee…
Ive manage to make this work again. the solution? I rebuilt the sourcefile from scratch.
well, not really from scratch. what I did is that I made a copy of a working dashboard and delete the components (left only those components same with the messed up dashboard) and one by one copied the components from the faulty dashboard.
what ive noticed is that, when you copy a corrupt component/s it resets when you paste it on a fresh dashboard. (formating, color, etc)
hope this helps someone who faces the same issue. or maybe there will be some fix from SAP in the future.
if there’s some easy way to work this thing out we’ve appreciate you sharing it.
Unfortuneately, Ive been through the same process many many times.
Just to add a final piece to this thread…
Scorecards, spreadsheets components are the most likely to make a good Xcelsius file go bad. Not that these are unstable components…they just seem to cause rendering problems. Re-doing them, via copy/paste or from scratch is a good place to start with fixing “stuck” models.
I’ve been having trouble generating a preview, where my preview gets stuck on “initializing…” I did some searching for solutions and found this thread.
Here is my current situation.
I have a spreadsheet with a couple of tabs and a bunch of formulas, including several OFFSET formulas. Right now I have only one component on my canvas, a Filter component. I’ve already deleted everything else.
When I click, Preview, it works.
When I add a SUM in one place, it stops working and gets stuck on “initializing.”
When I remove this SUM and put a SUM elsewhere on something else, it works just fine.
The difference in the two SUM locations is that the first one, which gets me stuck, is summing up a bunch of rows where I have OFFSET formulas. I mention this because I’m wondering whether something as simple as that makes this Excel file too complex for Xcelsius to handle. Could that be it? Any suggestions for me?
If you find yourself doing 1000’s of offsets, or trims, or other data manipulation, then the right answer is always go back to the dba’s to see if you can get a view that puts the data the way that you need it.
Also, How many rows of data is a “bunch” to you
Try putting the Sum on another worksheet.
Excel reads formulas from the left sheet to the right,
from the left cells in colA to the right and down.
Dont make the program backtrack to catch some values.
Here is an example of very bad design. The formula should be in C1.
…A…B…C
1.=B1+c1 50______100
also, dont have data blocks where you have full column gaps, or full row gaps. occasional blanks are tolerable, but not good practice.
all that being said:
I dont like the offset function in dashboards. That is a pure spreadsheet function, and I cant imagine how it would translate into actionscript/xml for the SWF. Is your Adobe Flash player current? There are probably faster ways to reconcile your requirements.
Right now I have 9 rows x 10 columns with an OFFSET formula that looks like this.
=OFFSET(K13,1+12*Summary!$L$7,6)
The reason this formula includes 1+12*Summary!$L$7 is because I am pulling in a different 9x10 set of data based on the selection made in another worksheet tab. If the user selects row 2 (using a Filter component) then these formulas will pull in the 2nd set of data. If the user selects row 3, then it pulls in the third set of data. Each of my blocks of data begins 12 rows from each other.
I’ll check out my flash version and your other suggestions.
Cairmor, thank you for taking the time to respond to my question.