Filtering on a lookup attribute in Report Model

Wednesday, January 21, 2009

I've recently created a Report Model with a Lookup Entity in it. I saw to it that I had only one default detail attribute for it, and I gave that attribute a ValueSelection of list. When I used the Report Model, I saw the attribute fine (as if it was inside the main Entity) but when I tried to filter on it I saw the Lookup Entity I was trying to hide and a filtered list. I couldn't understand why that was. I went back to check the attribute. Its ValueSelection was of type list. I went to the...

Slowly Changing Dimension Type 2 Tips & Tricks

Tuesday, September 9, 2008

Slowly Changing Dimension Type 2 Tips & Tricks I've blogged in the past about Slowly Changing Dimension Type 2, and I see that it's a subject that really interests you. I remember quite distinctly how hard and demanding it was to create it for my project (trust me I do!) and even to do it for two business entities. So, hoping that I may assist you even slightly, I thought I may share with you a few thoughts I have on the matter: Do you really need it? Now I know this is going to sound quite obvious, but before...

Creating a Report Model based on an Analysis Cube – Pros and Cons

Thursday, May 15, 2008

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...

BIDS Helper

Thursday, December 6, 2007

I know this means I'm quite late writing about it, but I only came about to learn about this Visual Studio.Net add-in quite recently and I wanted to study it for a bit before writing about it. The BIDS Helper is an excellent extension to the BI Development Studio which comes with SQL Server 2005. Though my main uses for it are for the SSAS part of my BI project, the newly released version also has features for SSIS. Among other features for SSAS, the BIDS Helper enables you to: Validate aggregations – checking whether the calculations you defined...

Looking at your Report on the Report Server

Friday, November 9, 2007

Continuing my theme of looking at things in the appropriate place, I thought I'd add another story. I was just building a report in Reporting Service, and defined the TextAlign property of the line to be "right". For some reason, when I previewed the report in the Visual Studio on my pc, in some cells the alignment was left and in some it was right. I found in a few occasions, that when it comes to viewing your report in SSRS, you should define all of your needs in the report and then deploy it to the server. It's...

Solve Order and how it can improve your MDX

Friday, September 14, 2007

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 of solve_order. If you do not mention...

The Many to Many Relationship

Saturday, September 1, 2007

So today's post will be about the usage of the many to many relationship that can reside between two dimensions. Quoting from the definition of Dimension Relationships, I would note that "Dimension usage defines the relationships between cube dimensions and the measure groups in a dimension…The many-to-many dimension relationship defines an association between a dimension and a measure group by specifying an intermediate fact table that is joined to the dimension table".       Now I know the usual example for this relationship is with bank accounts and people, as in: each person can have more than one bank account and...

Recreating an Analysis Services Project

Saturday, August 25, 2007

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 you! The way to do...

SSAS Back Engine and Named Queries in the DSV

Thursday, July 19, 2007

Hi everybody,   What’s up? Thought I’d share with you something strange I found while using named queries in the DSV layer in SQL Server Analysis Services. I have developed quite a complex layer of connected tables in my DSV. As development had evolved (with the customers demand) I found myself turning 3 of my regular tables into named queries. The named queries were basically using the same table twice in an inner join to compare the state of the entity in two different times in the table. After this change, my process time for the cube and the dimensions grew from about...

How to remember stuff…

Saturday, July 14, 2007

Well I admit I started writing this blog so I could be in touch with a larger community, but truth be told, I’m finding this blog has become a means for me to write stuff down somewhere so as not to forget them… J Let’s face it, even at the age of 27 I have a hard time remembering everything. So what can I do?  Notebooks with lists always seem to magically disappear or simply not be there just when you need them. Web pages, on the other hand, are always accessible – any place any time – and never...
no comments