|
|
|
|
Browse by Tags
-
Hierarchy handling in DAX is not very easy, due to the fact that hierarchies, unlike it was in MDX, are not first-class citizens in the DAX world. While hierarchies can be easily defined in the data model, there are no DAX functions that let you access, Read More...
|
-
As you might (or not) know, I travel a lot for work and, when possible, I always try to speak at local user groups. It is fun and I always learn a lot by speaking with other professionals like me. Being in Lisbon next week, I’ll deliver a speech at Microsoft Read More...
|
-
My 4yo son keeps asking me why I should leave home so often to attend SQL conferences around the world and today, after a couple of days of snow, he discovered a good reason, along with the best place for the SQLBits scarf. Read More...
|
-
What is a circular dependency? If A depends on B and B depends on A, then you have a circular dependency. As programmers, we know that they should be avoided to obtain a working system. All this looks fine but, when authoring a simple DAX formula containing Read More...
|
-
Data modeling in Tabular is different from Multidimensional. I spend much time teaching people that they need to change their mind when approaching the Vertipaq engine, because it is a different tool with different capabilities. Nevertheless, I still Read More...
|
-
This year I and Marco Russo will host a Birds of a Feather lunch about “ DAX, Vertipaq and BISM Tabular ” during PASS Summit in Seattle. If you want to spend some time speaking about DAX, the new Vertipaq engine of just have a good chat in front of some Read More...
|
-
Using Visual Studio to author SSAS Multidimensional projects, I was used to copy the project, deploy it with another name and then proceed with updates, until I was satisfied with the final result. Then, working with the two projects side-by-side I could Read More...
|
-
Having read this question on the mdsn blogs , I investigated on the KEEPFILTERS function and, after having learned it, it is now time to write about it. Moreover, before start to write about it, I need to thank the dev team of SSAS and Marco Russo who Read More...
|
-
September 29th I and Marco Russo will be delivering a full day of deep dive into the DAX programming language, during the training days of SqlBits 9 . Later on, during the conference, I will deliver a session about many to many relationships in DAX, exploiting Read More...
|
-
Tomorrow, at 11 AM CET, I will deliver a webinar on how to produce interesting reports with PowerPivot, a webcast which is a first taste of my incoming session for the European Sharepoint Conference. You can see all the details here: http://www.sharepointeurope.com/upcoming-webinars/self-service-bi-at-work,-an-example-of-a-powerful-user-created-report-in-powerpivot.aspx Read More...
|
-
A new date is available for the PowerPivot workshop I and Marco are delivering all over Europe. On September 19-20 , 2011 we will be in Lisbon (Portugal) to present the workshop to Excel users and BI professionals. Moreover, as Denali CTP3 of PowerPivot Read More...
|
-
Wow! Today I hit F5 on this interesting transaction: BEGIN TRANSACTION INSERT INTO World.Babies (Name, Surname, DateOfBirth, Gender) VALUES ('Arianna', 'Ferrari', '20110720', 'Female'); UPDATE World.Parents Read More...
|
-
In my last post about Parent/Child hierarchies , there is a question, in the comments, that I found interesting. Nevertheless, the formula is a complex one and cannot be written in a simple comment. Thus, I am making a follow-up to that post. I am not Read More...
|
-
Some time ago, I wrote a post about how to handle Parent/Child hierarchies in PowerPivot 1.0. It was pretty intricate, because P/C are not handled natively in PowerPivot. Now, with the advent of Denali, Microsoft gave us all the functions needed to handle Read More...
|
-
Surfing on the web, here , I came into this intriguing question: How do we ask something like "Show me how many customers have an iPad but don't have a book?" We are speaking about a sales analysis where the canonical entities are Customers, Products Read More...
|
|
|
|
|
|