One question came is "How to use Microsoft .NET Data Provider for Hyperion Essbase" on a workstation to develop Reports for Hyperion System 9.3 BI+ Enterprise Analytics.

Fairly simple, in order to use Microsoft .NET Data Provider for Hyperion Essbase you must first install "SQL Server 2005 Reporting Services SP2".

To make sure that the data provider is registered properly configure these two files "RSReportDesigner.config" on client and "RSReportServer.config" server - if already configured then ignore the remaining lines.

On Client locate "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSReportDesigner.config" and modify by

1- Adding this line in the <Data> section
<Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>

2- Adding this line in the <Designer> section
<Extension Name="ESSBASE" Type="Microsoft.ReportingServices.QueryDesigners.Essbase.EssbaseQueryDesigner,Microsoft.ReportingServices.QueryDesigners.Essbase"/>

On Server locate "C:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\RSReportServer.config" and modify by

Adding this line in the <Data> section
<Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>

Bandagi!