Hi! following with the migration from AS2000 to AS2005, my organization has 2
possible client viewers:
Excel 2000/2003 or BI Portal XP (2000)
In current version, we work with BI Portal, but for AS2005 we want to know if
Excel can be better than BIP.

The reasons are:

Web
Dont consume lot of resources
Save reports in folders
Sharing reports
Execute MDX
Can view more than 65000 rows
Excel needs licences for each user, BIP is free

The matter is that I don´t know if BIP 2000 can view details in drillthrough.
The IT people says that there is a requierment that clientes want to view
details.

I know that Excel can view details with a macro called Pivot Table
Drillthrough (for office 2000 and 2003)

If BIP can not access details, we could have Excel, but for the disadvantages
that I post, we preffer BIP.

--
If sun burns, sand too!

Message posted via http://www.sqlmonster.com

Hi,

May I suggest you to go to www.reportportal.com and download there the
free 60 days trial of ReportPortal for SSAS2000 + SSAS2005.

There you will see also the differences between SSAS2000 + SSAS2005 and
OWC. I am sure that after evaluating you will never want to go back to
BIP or OWC.

Regards, Marco

outrun via SQLMonster.com schreef:

Thanks for the link Marco.
Actually I know they are better options than BIP or OWC. Could be Rerpot
Portal, ProClarity, BusinessObject, MicroStrategy, Panorama. I would post a
thread about this.

But my question is:

If you must choose one of those (BIP XP or Excel) which one do you choose?
(considering that is temporally and the solutions like Report Portal would be
definitively.

And:
Can BI Portal XP work with SS2005?
Its beacusae it installs by default a database in a SS2000.

If can not work with SS2005, the winner is Excel.

--
If sun burns, sand too!

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200610/1

Hi,

You have to choice between a client solution or a server/client
solution/

Client solution: Excel with Pivot table services. Excel XP is
supporting SSAS2000 but SSAS2000sp3/sp4 is not supported and your
client should be updated. SSAS2005 is also not supported and should be
updated with the needed components or the addin for SSAS2005.

With a server/client solution you don't have trouble using client
components and/or supported server issues.

That is why I would always advise go for a server solution like
Panorama for the Enterprise or ReportPortal for less budget.

I have to say that ReportPortal is supporting more SSAS2005 features
than Panorama NovaView, like dimensions/measures groups + KPIs.

I understand from other people that BI Portal is not so easy to setup.
But no experience with that only I know it is OWC based so not all
SSAS2000 + SSAS2005 features are supported.

Regards,
Marco


outrun via SQLMonster.com schreef:

Marco, I have examined the Report Portal solution. It looks very good, but in
requirements Server side says:

Microsoft SQL Server 2000
Microsoft SQL Server 2000 Microsoft Analysis Services
XML for Analysis SDK 1.1
CDONTS Library (optional to send email)
Office 2000 Office Web Components (optional to create OWC snapshots)
IIS 4 or later
..NET Framework

You said that run in SSAS2005? (Maybe is an error in requirements) It only
need SSAS2005 or still want SS2000?
The 60 day evaluation period is renovable reinstalling? (Maybe not...)
Do you know hoy much is buying the solution? (I´m very interested in this
Software)

Please, tell us some of your experience with ReportPortal.

Thanks!

--
If sun burns, sand too!

Message posted via http://www.sqlmonster.com

Hi,

ReportPortal was developed as portal with support of SSAS2000 OLAP
Reports and OWC Reports as well. Now with the new SSAS2005 it is
supported as well, incl. dimension attributes, hierarchies, groups,
measures groups, udm, kpis etc.

With the portal you can both use and show SSAS2000 adn SSAS2005 OLAP
Cubes as reports in 1 portal.

Just download the 60 day full functional trial and publish reports
based on your own data.

Nice to use the SSAS2005 KPIs and show these in a report with click
through on a KPI to another report for more analyses.

By the way don't forget Reporting Services reports are supported as
well.

Product info:
http://www.reportportal.com/download.asp

Price info:
http://www.reportportal.com/products.asp

Ok it is not free, but the price is 100% worth the value !

Regards, Marco

outrun via SQLMonster.com schreef: