How can I use HypUIConnect without a friendly name?
Summary:
I need to convert multiple Smart View reports to point to a different database. The "from" and "to" database have different number of dimensions; some dimensions containing the same hierarchies have different dimension names. I can't just open connection to the new database and click "Ad Hoc analysis": it'd give me a message that certain dimension doesn't exist. I have to remove metadata and then do Ad Hoc Analysis - then it converts the report.
The problem is that I have hundreds of reports, and some of the reports use multigrid sheets. I developed a three-step process:
- Map the report. AT this stage, it just goes through every sheet of the reports, finds the one that have metadata using HypIsSmartViewContentPresent command.
Tagged:
0