I am trying to export a input box to a qvd file, the below script exports a table fine to a qvd file but it does not want to export the input box. Is there something i am missing or does this function not work with input boxes. If this is the case is there an alternative anyone can suggest to do this. I am using macros.
I cannot use a table as the variables i use are high lvl consolidated KPI values (YTD/MTD/YTD TGT). So when i use a table i need to add a dimension which i do not want. I just want the high lvl KPI values.
To give you an idea what i am doing: I have a main menu model with no data in but with buttons that will take you to detailed models, so i want to pull a few high lvl kpis to display on this main menu page from my models. But i do not want to pull all the data because i am running on about 100 mil aggr lines to date. So i want consolidated variables that can be exported to a qvd on post reload of my models then the schedule will run the main menu model and publish on web.