Save a spreadsheet in Application Dashboard

Question

Hello Team!I am trying to save a spreadsheet file using the native "Save As Application Dashboard File" button.&nbsp;

&nbsp;
I am running OS 7.4.2 but also tried on 7.4.1.It seems that it is only possible to save in a DEFAULT workspace on both OS version. Could someone confirm that?&nbsp;Now, if you save in a DEFAULT workspace under a specific Dashboard, I would like to know where is this file saved. I tried to extract the dashboard where I saved the file but nothing shows in the XML. So how do we extract it and where is it saved? I can see it in the Database under DashboardFileResource, but not under this Dashboard Files.

Thanks
&nbsp;

RobbSalzmann · Answer

Hi Nicolas, I ran into this as well working with Table Views. Named Workspaces are not completely working yet in 7.4.2 it seems.&nbsp;&nbsp;My way of doing it is to build as much in the worksheet as I can in Excel (named ranges, formatting, etc).&nbsp; Then I upload the file to a dashboard file, and reference that file in a Spreadsheet component using File Type Dashboard&nbsp; to find it.&nbsp; I continue to do most of the editing in excel, re uploading the changes over the existing file.&nbsp;

dkwiatkowski · Answer

Hi, can you provide all of the column values in the database screen print above?&nbsp; I would like to see what the Maintenance Unit Id contains.&nbsp; Since, I can only see the Workspace Id of all zeros it looks like you are saving a file to the Default Workspace and Default Maintenance Unit....which we shouldn't save files there since this is only for cube views 8.0 and data management 8.1.&nbsp; To be certain I would need to know the Maintenance Unit Id also.&nbsp; Thanks!&nbsp;&nbsp;

Forum Discussion

Related Content

Linking spreadsheets to third party application within OneSream

How to call a dashboard extender function from a Spreadsheet type BR?

Dashboards

Application Properties

Create Excel spreadsheet from Business Rules