With Analytics, we can export an Analysis to excel. But Can we export 2 analysis to the same excel file so that the file will contain the two analysis, each one in a single sheet of the file ?
Has anyone had to do this ? I looked everywhere, but wasn't successful , any idea ?
Thank you all !
Can u check this?
Mark help if answered.
Thank you Nagireddy, very interesting, but it seems this trick seems to work only in windows env since VBScripts only work on Windows. We have OBIEE on a Unix server. I'll go for calling a Java method from IBots, I'll keep looking, if I find something, I'll update the thread.