Report Portal

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
 xml for analisis server		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

johany

Ecuador
6 Posts
Posted - 10/25/2017 :  14:18:17  Show Profile  Reply with Quote
I can`t config the xmla URL.

How can I create a cube, and host it in xmla? I do not understand

please help me!

thanks

admin

1637 Posts
Posted - 10/25/2017 :  21:45:45  Show Profile  Reply with Quote
XMLA lets you connect to an SSAS (SQL Server Analysis Services) cube. It is Microsoft's way to access SSAS via HTTP.You can setup XMLA in one of three ways:

1. During the MSI installation

2. After installation by going to All Applications> ReportPortal > Setup ("C:\inetpub\wwwroot\ReportPortal\bin\XmlaSetup.exe")

3. Manually https://www.youtube.com/watch?v=tJGGyg1dDHY. After the manual XMLA setup, go to Admin > Connections and create “XMLA URL” type of connection with URL pointing to XMLA/msmdpump.dll
Go to Top of Page

johany

Ecuador
6 Posts
Posted - 10/26/2017 :  08:38:06  Show Profile  Reply with Quote
Hi.


Thanks for your answer.

I already tried what you tell me but I can not connect, I'm working with ReportPortal 5 and SQL Express 2008, is there any other way to connect and create the olap cubes?

Thanks for your help
Go to Top of Page

admin

1637 Posts
Posted - 10/26/2017 :  10:16:02  Show Profile  Reply with Quote
ReportPortal does not build SSAS cubes for you.

For a sample SSAS cube, download backup file http://www.reportportal.com/download/FoodMart2000.zip Open "SQL Server 2005 Management Studio. Right click on "Databases" and choose "Restore..."

ReportPortal can build ROLAP cubes (via Admin > ROLAP). You can then use the ROLAP cube via Design > ROLAP.
http://www.reportportal.com/Flash/ROLAP.html
http://www.reportportal.com/Flash/RolapAdvWorks.html
Go to Top of Page

johany

Ecuador
6 Posts
Posted - 10/26/2017 :  13:19:36  Show Profile  Reply with Quote
quote:
[i]Originally posted by admin[/i]
[br]ReportPortal does not build SSAS cubes for you.

For a sample SSAS cube, download backup file http://www.reportportal.com/download/FoodMart2000.zip Open "SQL Server 2005 Management Studio. Right click on "Databases" and choose "Restore..."

ReportPortal can build ROLAP cubes (via Admin > ROLAP). You can then use the ROLAP cube via Design > ROLAP.
http://www.reportportal.com/Flash/ROLAP.html
http://www.reportportal.com/Flash/RolapAdvWorks.html



please, I need to connect using xmla service but I can`t, I use ReportPortal 5 and SQL server express 2008.

thanks
Go to Top of Page

admin

1637 Posts
Posted - 10/26/2017 :  15:55:58  Show Profile  Reply with Quote
SQL server Express does not support SSAS
Go to Top of Page

johany

Ecuador
6 Posts
Posted - 10/27/2017 :  07:30:02  Show Profile  Reply with Quote
Hi.

I want to create a Bar Chart Tree Report but I can't connecting to any database origin or cube.

What can I do?

Thanks for your help.
Go to Top of Page

marco

Netherlands
588 Posts
Posted - 10/27/2017 :  07:39:05  Show Profile  Reply with Quote
Hi,

Do you have your SSAS Multi Dim or SSAS Tabular server working ?

If so you can connect with XMLA (as mentioned earlier)

If not you can use SQL Report or ROLAP Reports in ReportPortal to make amazing analysis and reports.
Go to Top of Page

johany

Ecuador
6 Posts
Posted - 10/27/2017 :  08:07:46  Show Profile  Reply with Quote
I can't to create a server SSAS because I'm working with SQL Express 2008.

In addition to the SQL reports or ROLAP report, I wanted to use the OLAP reports with SQL Express.

Can I do it any other way?

Thanks for your help.
Go to Top of Page

marco

Netherlands
588 Posts
Posted - 10/27/2017 :  08:33:40  Show Profile  Reply with Quote
If you have only a sql datasource than you can use rolap reports in reportal. First make a rolap cube in reportportal than you can connect to it and make amazing interactive reports.
Go to Top of Page

johany

Ecuador
6 Posts
Posted - 10/30/2017 :  08:18:37  Show Profile  Reply with Quote
Hi, Can you please help me with the ReportPortal price?

also where can I buy it?

thanks.
Go to Top of Page

admin

1637 Posts
Posted - 10/30/2017 :  10:19:32  Show Profile  Reply with Quote
Please contact sales@ReportPortal.com for a quote.
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