on 05-10-2013 1:16 PM
1) Excel file with 3 sheets.
2) Excel uses macros and data from sheet1 and sheet2 places output in sheet3.
3) On Dashboard some single values components will be used for analysis and that
Interactive data from single value components need to be taken out of dashboard.
4) Need to do calculations with sheet3 data. (single value components data and sheets3 data)
Final calculated/Analyzed data need to be shown on Dashboard and able to export the data to Excel after Analysis.
with no manual loading of data from import or export option in dashboard .
Hi Santosh,
Dashoard desgn (Xcelsius) will not support Macros, but we can import the spreadsheet but it will disable all of them during runtime.
Based on your requirement i can suggest you an alternative solution. If you are more familiar with Macros then create a macro which throws your output data (spreadsheet 3 data) in to an XML file.
Access this xml file through the XML data button or XML Maps button.
Hope this idea might help you
Regards,
Anjani Kumar C.A.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.