A few days ago, I wanted to start tracking on who was using my Tabular solutions. (If you wandered into this post… I’m talking about Microsoft’s SQL server Analysis Services.) With Multidimensional you have a table, that given the right…
Author: Steve Schneider
SSRS Data Source Lister
Hello, Sometimes, you’re in the middle of doing something, and you need an answer. You google it and find such a great solution, you want to keep it handy for … whenever! Here is such a post. As the title…
Reading an SSAS cube thru SQL using MDX
Do you need the ability to read a cube, but you want to read it thru SQL? And, why would you do this? Well, for example, suppose you wanted to email the results of a certain MDX query…and you didn’t…
SSAS not logging?
So you’ve followed all the advice and set up logging so that you can know who is using your cubes. Things are good. One day you wake up and see that your logs no longer are logging. You open your cube…
Who’s been using your Cube?
To keep track of how many people are actually using the results of your hard work… You have two considerations: 1. Turn on Logging on your Analysis Services Cube 2. Actually query that log…
Sql Saturday Jacksonville, April 27 2013
Hey, everyone! There’s a great event here in Jacksonville, Florida. It’s coming in April. It is like a mini Tech-ed. Free Food. Great Technical presentations. Lots of networking. Fellowship. Swag. After hours party. What could be better than that? I…
ASSP.dll…super great functionality
There is a “DLL” that you are going to want to install on your SSAS servers… it is called “ASSP.DLL”…and you can get it from Code plex. To quote CodePlex: The Analysis Services Stored Procedure project is a set of…
Tools to help you when developing SSAS cubes
There are a number of available tools that are free
SSRS subscriptions not working
The problem: SSRS Subscription is not sending out emails. Where to find a typical error-log: C:\SQLServer\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles
SSAS File organization
A few miscellaneous notes today on the location of various file when working with Analysis Services.