Creating a slicer based on that parameter table.Building a parameter table in the Power Pivot data model, that includes a column with all the names of the Named Sets (e.g.And this is where the naming convention of your Named Sets comes back into the game. The good news is, that the xVelocity engine, which stands behind Power Pivot, understands both: MDX and DAX □ This is something I learned from Idan Cohen’s post about Dynamic Chart in Power Pivot on. Now, that we know how a Named Set looks in MDX, there is one more question to overcome: How can we make this Named Set react on a slicer? Let’s focus on line 2. This line consists of a selected month (in this case January 2003) and a measure (MIsoActYear_TotalDue = TotalDue of the isolated January in Year 2003). See the following figure.īecause we created all the Named Sets on columns (not on rows) each line (except line 1 and 7) in the MDX statement represents a column in the pivot table. As I sayed before: For getting an perfectly technical background on MDX for PowerPivot read Chris‘ posts. See the MDX behind Named Sets in Excel – Step04 See the MDX behind Named Sets in Excel – Step03Īfter confirming with OK you see the following MDX statement. But have you noticed the little button Edit MDX on the lower right? Click on it (1) and confirm the appearing warning with OK. Here you created all the Named Sets so far. The following windows is already your good friend. See the MDX behind Named Sets in Excel – Step02 Select the Named Set you want (1) to see the MDX statement and then click in Edit (2). The next windows, that opens is the Set Manager. See the MDX behind Named Sets in Excel – Step01
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |