Imported Web-I report in Excel Using Live Office
-> Live Office refresh options: Use Report Saved Data
Published excel im BOE
Created Dashboard by importing this excel from BOE.
Used ‘Connection Refresh Button’ to refresh dashboard
-> Data Manager-> Live office connections
->Session URL (OK) --> Usage refresh every 5 seconds.
My dashboard gets refreshed properly.
Issue is that for the first time when it gets automatically refreshed (due to 5 sec. setting), it asks for BOE logon credentials. When I provide these credentials (username/password) for the first time. It works fine and don’t asks next time and everytime refreshes automatically.
Please tell how to eliminate this first logon window. I don’t want to provide username/password even for the first time. It should automatically get refreshed from first time itself.
Thanks
I think you are talking about publishing swf file in infoview. I agree in that case it wont ask for entering credentials. Because we already provide them before entering in infoview.
However, my swf is residing outside infoview. My requirement is such that i can’t place it in infoview. Any solution in this case.
you’re using BOBJ specific functionality (webi and Live Office) and you want the dashboard to live outside of BOE?
Probably better to use XML, but you could do this using QaaWS. QaaWS let’s you hardcode the BOBJ login and password. Look in the data/connections after you bring in a QaaWS connection. sorry for the delay in getting back to you, I was on holidays.
we had the same problem and ended up using QaaWS for the swf’s that were deployed outside of InfoView. however, our dashboards are near real time and this caused yet another issue for us.
LiveOffice can retrieve data, say every 2 minutes, from a scheduled webi report. so if you have 20 queries for a dashboard, the actual queries only execute once every 2 minutes by the webi report. so every 2 minutes your BO and DB servers must service 20 queries no matter how many users are viewing the dashboard.
QaaWS cannot retrieve data from a Webi report. this means that if you have 200 people viewing the dashboard, then every 2 minutes 4,000 queries fire off… ouch!
Real time dashboards are better served with LCDS. Far more scalable.
You could try to re-configure your Webi report however. Why not use fewer webi reports with more data providers? One Live Office piece would call a section of report.
I’m not very familiar with LCDS but my understanding is that the architecture is the same as using a web service so the number of database calls would be the same. Maybe LCDS handles the throughput better but ultimately the load on the DB server is the same as using a regular web service.
The issue with using Webi really doesn’t have to do with the data providers, at least not in the context being discussed here. The problem is that only LiveOffice can retrieve data from a Webi Report and therefore the user must authenticate if the swf is published outside of InfoView.
Hi,
Under data the tab definition is splitted in horizontally in two parts. On the left side you can see the method name. underneath you should see at least username and password and then according to your qaaws query 0 to x parameters.
You can either hardcode username and password by clikcing the items in the tree and fill in the info in the blank white inputbox, or you can define a cell in the excelmodell where this information is stored
Hope this helps
If i write my id and password in cells in Excel and then pass in Data manager connections-> Qaaws-> input values ->login and password, it gives me the error FWB 00008(Entreprise authentication could not log on).
I use Windows AD for my authentication
What should I do for not appearing the prompt for Logon credentials?
Hi Simona,
Sorry for my late reply - i was in parental holidays and had no access to any Systems
Every Windows AD Account can have an enterprise alias. The alias and the windows ad account then run under one account (usually the enterprise account) and rights and so on can be handled with this. If you logon with Windows AD in Infoview your AD Account is mapped to the enterprise user and everything should be fine. I would assume that you ask your BO Administrator to create such an enterprise alias for you so that you can use it. I think there is no way to change the authentication mode within xcelsius - not that i know right now.
After you havce received this enterpriseuser use its passwort to hardcode the login credentials.
(BOB member since 2009-05-09)
(BOB member since 2002-08-15)
(BOB member since 2006-10-12)