Browse by Tags

OLAP Connectivity from Pivot Table in Excel - security permissions

Published 25 September 7 4:14 AM | SSQA.net

Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database...

Filed under: sql server, security, ssas, ssms, olap, excel, pivot, execute, credentials

BI Survey - world's largest independent survey about your experience

Published 10 July 7 12:59 PM | SSQA.net

If you would like to share your experience in managing Business Intelligence products and applications that are used in business/corporate/enterprise performance management, as a whole it is called OLAP. This survey is to help in identifying the trends...

Filed under: sql server, bi, ssas, olap, survey