Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created QVW document and now want to connect it to the existing management report pack in Excel. It is currently linked to TM1 and feeds data from it via DBRW formulas. I want to relink it to QV. I think I have two alternatives - export data from QVW to the reporting pack, say into auxiliary worksheets and then link into existing report templates or somehow write formula/VBA code that will return the value from QVW. I want to follow the second option and just don't how to approach the issue. I would appreciate simple guidance or advice in simple terms, may be like this:
1. Create excel
2. Open VBA editor
3. ...
4.
I managed to find sample xls which reads all variables from QVW by Tim Benoit and not sure if it is possible to modify to return set analysis results.
Thanks beforehand.
try sending results to excel (csv)
Doesn't help that much, the text file became bigger than QVD by 40 times and doesn't load into Excel in full (more than 5 mio records). It would be nice to have a piece of code that can pull just one value from QVD. I looked at Nprinting and vizubi, but the problem is I can't install other software.