Change the name under ‚Table Name‘ (Step 2) in what ever you like. This is not strictly required, but it’s pretty usefull. That way the name of your table in Excel and the name of the table in the data model are equal. ![]() ![]() The advantage of going this way is, that you can change the table name, before you add that table to the data model. Now we convert these two columns into a table the following way: When you will create further Named Sets in the future, it will be pretty easy to enlarge the parameter table within seconds. This is important for the MDX-statement, which will let us control the Named Sets by Slicer. Only those two months appear in this table now. One for March 2003 and one for April 2003. You need to ensure, that in this table are only those months represented, for which you already have created a Named Set. The data looks like this: Building a parameter table I open a new excel sheet within the same file. This will be read by the Named Set and will change the pivot structure accordingly. Our table will have two columns:Ī) Column ‚Caption‘: This column will be shown in the slicer and will let the user select the year-month-combination.ī) Column ‚YYYYMM‘: This column will show the year-month-combination as number. ‚Parameter table‘ is another word for disconnected table, which is a single table in the data model, that has no relation to other tables. Let’s move on □īuild a parameter table in the Power Pivot data modelįor being able to control Named Sets via Slicer, we first need to create a parameter table. These four steps make it happen, that you can control your Named Sets by slicer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |