Posts tagged "olap"

Microsoft Analysis Service (OLAP) Front-End

Option for MSSQL Analysis Service (OLAP) Front-End 1.Microsoft SQL Reporting Service SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. It is administered via a web interface 2.Microsoft PerformancePoint Service PerformancePoint Services in Microsoft SharePoint… Continue reading

SSAS: MDX Average Script On SSAS 2008

The MDX script on Microsoft Analysis Service (SSAS) 2008 and 2005 are different from SQL 2000. Here’s an example how to calculate average using MDX script on Analysis Service 2008. SSAS 2008, How to calculate Net Value By Date (NetValue / Date)

Old one, SSAS 2000, How to calculate Net Value By Date (NetValue… Continue reading

SAP BW, Documentation (1)

After getting to  know and familiar with SAP BW basic T-CODES. I found another website to help mastering SAP BW is http://sap.seo-gym.com/. Lots of goodies relating  SAP BW, such as tutorials, learning guides and help files containing PDF or Microsoft Documents (Doc) . Interesting, I thought the page/sub domain is a technic for Search Engine… Continue reading

SAP BW : Cannot delete DTP

Problem: Cannot delete Data Transfer Process (DTP) from DSO/CUBE to DSO/CUBE. Despite all the pre-conditions have been met, such as deleting data and requests in the target and source. Error Message: Delta DTP cannot currently be deleted (see long text) Message no. RSBK037 Diagnosis You want to delete a delta DTP that has been successfully… Continue reading