Browse by Tags
All Tags »
MDX (
RSS)
This blog is SUPER SUPER excited, because for the first time, after four years, we have a guest! I met Mr. Kobi Deutsch in the SQL Explore Convention held about two weeks ago. During a session we both took there, he mentioned something I wasn't aware and I thought maybe I'd bring it to you as well. So, I'm leaving the stage for Mr. Deutsch: Sometimes, when we check the MDX requests in the Profiler, we see that there is a partition that was scanned and loaded into memory although it is...
Ok, so the unexpected happened - about a month and a half after interviewing Mr. Donald Farmer , I got to interview Mr. Amir Netz and Mr. Ariel Netz ! I know!... You probably remember Mr. Amir Netz from his appearance in the recent keynote session in the BI conference in New Orleans. He spoke about what's going to be new in PowerPivot. When I heard he was coming to Israel for a conference discussing Panorama and PowerPivot , I decided I'd try to get a few more tidbits from him... In the keynote...
If you're following this blog, then you know that Sunday, May 30 th 2010, I went to the SQL & BI Data Platform convention held in Tel Aviv. Specifically, I went to Mr. Donald Farmer 's seminar on Data Integration in Large Organizations . I did live blogging from most of the event, though actually, I didn't manage to blog about the last part of it, because I was preparing for something that was pretty big for me.... I'll start over. When I first heard Mr. Farmer was coming to lecture...
A colleague of mine ran into a peculiar problem with her cube. She deployed it just fine and didn't get any error messages. Still, there was a problem. She could see the dimensions in her SSAS project just fine. She could see her cube as well. But she couldn't see any of her measure cubes. So what was the problem? She was missing the calculate statement from her cube. If you look in the BIDS at your cube on the Calculations tab with a Script View, you'll be able to see that the first...
Creating a Report Model based on an Analysis Cube – Pros and Cons If you follow my blog, you probably know by now that I developed a report model based on the Analysis Services cube I already had. I even got around to updating the report model . And then, my users started using it. And you know, whatever we do just seems so wonderful to us, until our users find all sorts of flaws with what we did… so yes, my users did open my eyes to quite a few problems that may occur when you build...
Well I thought today we'd go over visual totals in MDX and also see how they may have an impact on how you assign role based security in you SSAS project. Visual Totals in MDX are there to give you just what they describe – a sum on the children in a certain set. Child members which are not in the specified set will be ignored during the calculation. For instance, if I have a set that consists of: USA, New York, Washington and California, when I look at the total for USA, I will only see it's...
Well I guess congratulations are in order because I finally got around to using a report builder in my project. Turns out that building a report model based on a cube is as easy as 1-2-3. Still I had a problem, as for some unknown reason the translations were showing for my dimension names and my measures, but not for the dimension's attributes... At first I thought maybe this is a problem solved by Service Pack 2 (as my tests were done on a Server with Service Pack 1). Alas, no. So, a further...
You can browse a cube through the cube browser in Analysis Services or through the one in the Management Studio. I usually use the one in the Management Studio, as it gives your more space to look. In the cube I created in Analysis Services, I added a Budget hierarchy in my Budget dimension. I decided to check the data for the new hierarchy in comparison to the money that was assigned to it in the Budget fact table. And it was problematic… I was opening the Budget hierarchy and in the first 3 levels...
Panorama Nova View Analytics is a viewer on a cube which enables you to drag and drop attributes and measures onto a grid, so as to study the influences different slicers and dicers have on a measure. Each combination of slicers and dicers with a certain measure, can be saved as a presentation (the name in Panorama for a dynamic report). The presentation is dynamic, as you can change not only the filters on the existing attributes (as in Reporting Services), but also add new attributes and remove...
I thought this time around, we'll discuss how solve order can affect your MDX calculations. I found that people tend to ignore this property, as it is not mentioned in the "Form View" of the Calculation Tab of the cube (which is what people usually tend to use when they write MDX for a cube. I hope this will be taken into consideration in SQL Server 2008). Now, this is a shame, as solve order can greatly affect your calculations. For each calculation you do in MDX, you can specify the optional property...
Well, continuing our story about strange things that can happen, I thought I'd share with you this little tidbit. I was taking over a project from someone who had left the company a while back. In the cube that was on the old server, there was an MDX calculation. Only thing was that calculation was missing from the project on the new server (and I admit I couldn't guess what was behind it). So what can you do when you need something that in a project of an old cube? You import the project back to...
…like for instance, it could all of a sudden turn into a ball! J Ok bad computing joke. So this time around I thought I'd tell you about a weird incident I had with my cube. I found out I could see my cube in the Management Studio and even browse it, but when trying to run an MDX on it (again, in the Management Studio) it would tell me I didn't have any cubes for the MDX to run on.. I could still run MDX scripts on it in my SSAS project so I continued as usual, thinking to myself only that this is...
We define names for our tables and columns following the guidelines defined in our company. we might even adhere to international naming conventions. Still, nothing promises us the names we give our DB objects will be comprehensible to our customers. And this is where SSAS steps in - Analysis Services enables you to give alternative names to your dimension attributes in the following two ways: Translations may be given to: dimensions, dimension attributes, user hierarchies, measures, measure groups...