ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Problem in Creating OLAP Reports

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
madhankumars 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
11   L A T E S T    R E P L I E S    (Newest First)
pcl_xl 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.
marco 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
andre.wihardjo 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.
pcl_xl 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.
pcl_xl 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.
marco 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 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.

Free Image Hosting at <a href=www.ImageShack.us" />

QuickPost Quickpost this image to Myspace, Digg, Facebook, and others!

Thank you.
admin Posted - 03/13/2009 : 21:24:54
Have you tried to access the application from another computer?

Which build of ReportPortal have you installed? (You can see by going to http://localhost/ReportPortal/BuildNumber.txt)
marco Posted - 03/13/2009 : 12:33:25
Hi,

Just uninstall ReportPortal and try to install ReportPortal with SQL Server 2005.

If you are using Windows 2003 your can visit also:
http://technet.microsoft.com/nl-nl/library/cc917711(en-us).aspx

Marco
madhankumars 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 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

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page