Hello,
We have a cube view with a couple hundred rows, when in the designer view it is hard to find the row we want to edit since it reads the row number vs member info. I know it's possible to update the name but that would be tedious to do one by one. Is there a setting or rule that would override the row name to equal the member number/name/description?
For example "Row192" would read "LE30102" or the actual description.
Thank you in advance!
Rana
Hi Rana: a couple of possible suggestions for you here.
1) "Is there a setting or rule that would override the row name to equal the member number/name/description?" None that I am aware of (although I welcome others feedback). Best practice would be to populate descriptive row names as you are building the cube view.
2) Instead of the Designer, if you go to the Advanced tab -> Rows: you'll get a slightly easier to navigate list. That might be a starting point.
3) I have to ask...hundreds of row sections in a cube view? Can you use member expansions instead of making them individual row sections?
4) If going through with the update to the row names is a requirement I'd approach this by exporting the cube view to xml via Application Load/Extract, writing a PowerShell (or Bash) script to do the structural editing for me, and then re-importing via Application Load/Extract. ChatGPT typically nails these types of scripting questions for me.
Edit: if you go this route, make sure to backup the original cube view / import using a slightly different name.
Cheers, db.
