SSAS and SQL Browser Service

After installing SSAS 2014 on maching running SSAS 2012. SSAS 2012 became unresponsive and the ETL job crashed. The message was: Microsoft.analysisservices.xmla.CONNECTIONEXCEPTION: a connection cannot be made TO redirector. ensure that ‘SQL Browser’ service IS running. -> system.net.sockets.SOCKETEXCEPTION: no connection could be made because the target machine actively refused it 127.0.0.1:2382 at system.net.sockets.tcpclient..ctor(string hostname, int32 port) at microsoft.analysisservices.xmla.xmlaclient.gettcpclient(connectioninfo connectioninfo)   It is important to remember that SSAS can be accessed through SQL Browser Service. I went to SQL Server Configuration Manager (Start > Search > > Configuration Manager). I found the SQL[…]

Troubleshooting SSAS

If the service is not responding, check the SSAS log: If one session is not responding, open an MDX window in SSMS and run the following: SELECT * FROM   $system.discover_sessions ORDER  BY session_used_memory DESC If looking for active sessions, filter by: where SESSION_STATUS=1 or SESSION_IDLE_TIME_MS=0 Question: How To differentiate between queries and SSAS processing commands? Run a simple processing and check the SESSION_LAST_COMMAND. If[…]

Fix: Cannot query internal structures for column because they are not processed

Cannot query internal structures for column T1[C1] because they are not processed. Please refresh or recalculate the table T1 Cannot query internal structures for column because they are not processed. Please refresh or recalculate the table SSAS processes tables in different options, most important ones are: Process Full Processes a table object and all the[…]

Multiple Date Dimensions in SSAS Tabular

SSAS Tabular has a limitation: It doesn’t allow dimensions to play multiple roles. A common scenario is you have an order with multiple date: Call Date, Order Date, Ship Date, etc. Adding multiple date dimensions in SSAS Tabular is not intuitive: First you need to import the date dimension multiple times, and make sure you[…]

DAX functions I liked

So as I am developing DAX formulas for PowerPivot, I got to learn really nice functions that I found interesting to share: Divide by Zero Solution: DIVIDE: DIVIDE(Nomenator, Denametaro, alternativeValue). Now you have the divide-by-zero handling really easy with one single parameter “alternativeValue” showing what to show when you are in such situation. And even[…]