Save a spreadsheet in Application Dashboard

NicolasArgente
Valued Contributor

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

NicolasArgente_0-1694421597941.png

 


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? 
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.

NicolasArgente_1-1694421646718.png

NicolasArgente_2-1694421674762.png

Thanks

 

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.
2 REPLIES 2

RobbSalzmann
Valued Contributor

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. 

 My way of doing it is to build as much in the worksheet as I can in Excel (named ranges, formatting, etc).  Then I upload the file to a dashboard file, and reference that file in a Spreadsheet component using File Type Dashboard  to find it.  I continue to do most of the editing in excel, re uploading the changes over the existing file.

RobbSalzmann_0-1694442113097.png

 

dkwiatkowski
New Contributor

Hi, can you provide all of the column values in the database screen print above?  I would like to see what the Maintenance Unit Id contains.  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.  To be certain I would need to know the Maintenance Unit Id also.  Thanks!