| Author |
 Topic  |
|
|
madhankumars
2 Posts |
 Posted - 03/12/2009 : 07:22:02
|
Hi,
I am new to ReportPortal. I have installed the reportportal in my machine and create xmla connection sucessfully. When I create a cache, the application reterive all the SSAS cube information from my server. But, when I Open the OLAP report, the screen shows the link "Connect to cube/ Open Report" and "loading..." status message in middle of the page. I try to click on the "Connect to Cube" link, but nothing happened from there. This is very critical. Please help me to resolve this.
Thanks!
Madhan |
|
|
marco
Netherlands
588 Posts |
Posted - 03/12/2009 : 08:20:46
|
Hi,
Which SSAS (SSAS2000, SSAS2005 or SSAS2008) are you using ?
In ReportPortal you can test the XMLA connection. Is this working without errors ?
If so you can make an OLAP report based on the XMLA connection.
After that you can cache the SSAS Cube information as part of the connection and choice which lanquaqe your would like to see.
Marco |
 |
|
|
madhankumars
2 Posts |
Posted - 03/12/2009 : 21:48:25
|
Hi Marco,
Thanks for your quick reply.
I am using SSAS 2005. while installing report portal, suddenly a window appeared in the middle and when I click "OK", it show a bunch of errors. I have tried different options nad nothing worked out. So, I changed the servername it the url(http:///xmla/msmdpump.dll) as "localhost" (http://localhost/xmla/msmdpump.dll) and clicked ok button and a message "success" is displayed. Is that correct?
Thanks!
Madhan |
|
|
|
marco
Netherlands
588 Posts |
|
|
admin
1644 Posts |
|
|
pcl_xl
11 Posts |
Posted - 03/23/2009 : 21:39:08
|
Hi,
im also having the same problem. Just like what Marco said, i've gone through the microsoft technet forum but still the same problem occur. In my case, i am using SSAS2005. The XMLA connection is good. There's no error in the conenction. Im trying to give you a screenshot. Maybe it can help you explain the problem. Just click on the link below.
 www.ImageShack.us" />
 Quickpost this image to Myspace, Digg, Facebook, and others!
Thank you. |
Edited by - pcl_xl on 03/23/2009 21:42:00 |
|
|
|
marco
Netherlands
588 Posts |
Posted - 03/23/2009 : 23:51:29
|
Hi,
Did you test the XMLA connection ?
in ReportPortal > Admin > Connection to see if XMLA is working ok in ReportPortal ?
In IIS Admin is XMLA with Net 2.0 and in XP with Integrated or Basic or anonymous access rights ?
If the connection test in ReportPortal Admin Connections is ok than you should see OLAP Cubes. Maybe a strange question but do you have OLAP cubes on the server where XMLA is setup with the right users to have access ?
Try in any way to use Foodmart or AdventureWorks as sample to test first before goning on your own Cubes.
If there are some questions, please let me know. I have it working in Windows XP SP2, Windows 2003 Server, Windows Vista with SSAS2000, SSAS2005 and SSAS2008.
Marco |
|
|
|
pcl_xl
11 Posts |
Posted - 03/24/2009 : 00:10:41
|
Yes Marco,
actually that is our problem. We have done all thing, even the XMLA connection. It's working. .Net Framework registration OK, testing the IIS using aspx code is also OK. Seem everything is okay except this one.
Now i'm trying to download the new Build of Report Portal to see if this problem occur in the new Build also.
FYI, i'm using Windows Server 2003 Enterprise Edition with SP1, SQL Server 2005, SSAS 2005.
Has Madhankumars solved the problem? Can you please share the solution? Thank you. |
|
|
|
pcl_xl
11 Posts |
Posted - 03/24/2009 : 00:23:23
|
| Oh btw, the OLAP CUBE is also in the same server with XMLA. I can use the OLAP CUBE by connecting using MS Excel Pivot Table from any computer to the server. |
|
|
|
andre.wihardjo
Indonesia
12 Posts |
Posted - 03/24/2009 : 01:19:45
|
Hi PCL_XL,
I have an issue like this and problem solved when I reinstall with the new ReportPortal (build number 160).
Please check your build number, I got this issue when use ReportPortal with build number 158.
Thx. |
|
|
|
marco
Netherlands
588 Posts |
Posted - 03/24/2009 : 02:05:17
|
Please uninstall and install the latest build 161 of 3-3-2009 and let me know if it is working now.
Marco |
|
|
|
pcl_xl
11 Posts |
Posted - 03/24/2009 : 02:32:17
|
Hi Andre & Marco,
It works. I uninstall the Report Portal, XMLA SDK, and remove the virtual directory from Default Website on IIS. Then i re-install the XMLA and Report Portal using build 161. Now the problem solved.
From my opinion, this issue might be caused by the installation of SP1, since i was using the earlier build number before.
Maybe this can also solve Madhankumars' problem.
Thank you. |
|
|
| |
Topic |
|
Report Portal
Problem in Creating OLAP Reports
www.ImageShack.us