on 07-01-2015 1:59 PM
Hi All,
We have developed a Live office connection in Dashboards 4.1 and source for Live office is webi report and for webi data is getting from Bex. I have developed the report successfully and now I have to give prompts to Live office connction.
Also the data in Live office is not updating dynamically.
Please suggest me how to make Live office data dynamic and create prompts for live office.
Thanks
Saroja
Hi Saroja,
You need to have prompts in webi report itself.
After creating the LO connection on webi go to Live office tab -> Go To Object.
Click on the webi object and select refresh object. This will ask for prompt values and refresh your report based on the prompt value.
When the report is refreshed go to Modify Object and select prompt settings.
You have 3 options -> Always ask, from list, bind to cell.
Choose whichever is desired.
Also I would like to inform you that the bext practices for creating Dashboards on LO is to create the LO in excel outside Dashboards. Later save this file and import it in Dashboards. After importing add the LO connection in Data Manager. Also do not forget to update the servername and port in session URL.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhilasha,
Sorry for the late reply.
Thanks for your solutions. It is working fine.
When I click on"Refresh all objects" then data is refreshing in LO spread sheet, If not no.
Now I want to happen it dynamically means with out clicking the Refresh button data has to get refresh at LO spread sheet.
Please provide me a solution.
Regards,
Saroja
Hi Saroja,
In the LO -> Modify object -> Prompt setting you have an option to bind the prompt to a cell.
If you choose to check the append parameters option you will get LOVs for the prompt in the cell that is bind. If not there wont be any LOV but you have to enter values manually.
Whatever, after you select/type the value and hit enter the Lo will refresh and bring data as per the prompt value provided. If you dont hit enter it will not refresh. If this works fine, import this LO spreadsheet to Dashboards.
Later in dashboard you can have a selector component(Eg: combo box) to get the prompt value from the end user and again bind it to the same cell. So that the prompt value is passed to the cell and to the LO connection.
Now for refresh, go to Usage tab -> select refresh on trigger and map the trigger cell to the same prompt cell.
Map the trigger cell to only one cell not to entire range and then check the issue.
And you have mapped it to an area where the LO gets data. It should be mapped to the cell that contains prompt value.
Eg: Your A1 to F50 contains data. And G1 is mapped to prompt. Then the trigger cell will be G1.
And whatever prompt is recieved from end user either by input box or combox that must be
inserted in G1.
Hi Abhilasha/Suman,
Thanks for your time and detailed reply
I have followed steps but couldn't get expected results.I have followed below steps
1)Live office tab -> Go To Object. -> select the Webi Report
then Modify Object ->prompt settings
Then selected the prompt values, mapped the prompt to a cell & Refreshed the object.
2)Moving forward I mapped the cell in Data->connection->Datamanager->LO connection
3) Assigned the prompt cell to a Combo box
4) Preview the report, I created the prompt for the cal month field but it is showing other object data in prompt cell
Below component to the chart is List view to check which value is populating in prompt cell.
5) To the surprise it didn't asked for the prompt at the time generating report and it encountered the error as well.
Please suggest me where I am going wrong and please guide me how to achieve this.
Regards,
Saroja
Hi Saroja,
In the combox properties, your source is A2 to D12. Now when you select the label from the combo box, the respective row will be selected. And the same row will be inserted in the destination. But your destination is a single cell.
Now you have to map the destination to a row like the source. Now this row will have a cell that you need to pass as prompt. Map this cell for LO prompt and trigger cell.
The problem caused here is because of the source and destination. If you correct that it would work fine.
Regards,
Abhilasha
Thanks Abhilasha,
With your help I am almost done but I stucked up in combo box.
Please see below steps which I followed.
1) I can able to see the prompt drop down list in my spread sheet and it is refreshing as well
2) I have mapped this to a combo box
3) In Data-> connection->datamanager-> Usuage, I mapped the cell.
4) When I preview this I couldn't find the list of values in combo box istead only one value is displaying.
Please let me know how to get all the values which are showing in prompt in spread sheet.
Regards,
Saroja
Hi,
Check attached SAP Idea link. as per this prompts are not supported with BICS in LO.
Need prompt in LiveOffice from WebI (with Bex BICS connection ) : View Idea
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.