Forum Discussion
Display mutliple columns under a Name (No hierarchy /No grouping)
HI,
I am building a cube for which in my dimension tables where i have to show fields as a hierarchy and at the same time, the fields must be shown in single.
Eg : i have fields name Device Name, Device Make, Device Model, Device Type
Expected Output : Device Hierarchy -> Device Name, Device Make, Device Model, Device Type
More Fields -> Device Name, Device Make, Device Model, Device Type
How to bring it up.? kindly suggest.. i need a More Fields Name just to populate where we can drag and drop the columns under it for individual data view
HI Tahreem and Zhengdong Xu,
The solution is sorted without creating DAX / Table. In data Modelling for cube, below are the steps.
1. we have to select device_code (under my scenario here), Just type name "More Fields" under Display Folder and make it visible . Note: Type the text More Fields without quotes.
2. CTRL+CLICK the remaining fields which to be listed below, and give the name as More Fields\SubDevice and make the remaining fields as Visible here too. Note: After \, the name can be any.For my scenario, i have kept the name as SubDevice.
3. On Saving, we will see multiple sub folders in desktop, once published, all the fields will show under 1 name "More Fields". Here it go!!! Thank You Both for considering the post and have given your valuable inputs too.
9 Replies
HI Tahreem and Zhengdong Xu,
The solution is sorted without creating DAX / Table. In data Modelling for cube, below are the steps.
1. we have to select device_code (under my scenario here), Just type name "More Fields" under Display Folder and make it visible . Note: Type the text More Fields without quotes.
2. CTRL+CLICK the remaining fields which to be listed below, and give the name as More Fields\SubDevice and make the remaining fields as Visible here too. Note: After \, the name can be any.For my scenario, i have kept the name as SubDevice.
3. On Saving, we will see multiple sub folders in desktop, once published, all the fields will show under 1 name "More Fields". Here it go!!! Thank You Both for considering the post and have given your valuable inputs too.
Tahreem24Super User
Anonymous Not sure whether I understood you question properly or not. Based on my understanding, you want one hierarchy as "Device Hierarchy" which will contain Device Name, Device Make, Device Model, Device Type fields? If yes, so you can create hierarchy and keep adding these fields. Link
Next question, what I understood is you want to show all these fields in together? If yes so you can concatenate all these fields with "&" sign and separated by "-" as a new calculated column.
New Column = [Device Name] & "-" & Device Make & "-" & Device Model & "-" & Device Type
I hope this may help you!
Hi Tahreem,
Thank you first of all for the quick response. First one, creating hierarchy, i was able too. But for the second, i want to show individual one (not concatenated) one below the other but not as hierarchy.. just like an expand/collpase option which it can be seen in cube.
Example as shown : more fields shoultnt be a hiearchy..
- Tahreem24
Anonymous For "More Fields", either you can accomplish with creating hierarchy (which you already did) OR you can create a new table and add only these fields.
New Table = SELECTCOLUMNS(YourTableName,"DeviceName",[Device Name],"DeviceMake",[Device Make])
Note: Add more fields in above DAX as per your requirement.