ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Change XMLA Connection of OWC Report
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pinkzfairy

Indonesia
2 Posts

Posted - 07/14/2015 :  20:05:00  Show Profile  Reply with Quote
Hi all, i would like to seek help on my migration process. I am migrating my reports from SSAS 2008 to SSAS 2012 and currently i am using OWC Report with XMLA connection.
I am having difficulty to change my connection of all my reports to new connection(SSAS 2012). Is there any simple way to change my connection instead of doing it one by one?

admin

1637 Posts

Posted - 07/14/2015 :  20:24:48  Show Profile  Reply with Quote
Yes, please go to Admin > Edit Report Schema > select "Search and Replace" tab. For example,

Search: Provider=MSOLAP;Initial Catalog=Adventure Works DW;Data Source=http://www.reportportal.us/xmla/msmdpump.dll

Replace: Provider=MSOLAP;Initial Catalog=Adventure Works DW;Data Source=http://www.reportportal.us/xmla2012/msmdpump.dll
Go to Top of Page

pinkzfairy

Indonesia
2 Posts

Posted - 07/15/2015 :  00:21:56  Show Profile  Reply with Quote
Already try it and it works.
Thanks a lot :D
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page