Maybe this is a bit out there… but what if there was a “Dimension Builder” tool within Database Designer?
My use case is that I wanted to create a sub-dimension called “Market” on my Sales database to be able to group my price branches. I think that’s a pretty common thing for people to do. What I ended up doing is making a quick CSV containing 2 columns - Branch and Market. I uploaded the CSV to my files on Designer and dragged it onto the Price Branch dimension as a data item. I tied the Branch to the Price Branch, then used the Market column to create the sub-dimension of Market under Price Branch.
The issues I foresee with this are mainly maintenance related. When a new branch is added in the future, I will have to update my CSV file then re-upload and Replace the data file. Otherwise, I could make it a Sync item but I would still need to manage the spreadsheet off of Phocas. This also limits the maintenance to be done by me unless somebody else has access to the spreadsheet.
If there was some type of Dimension Builder that lived within Phocas, then I (or anybody with proper permission in the future) could theoretically manage this from right within the tool. I would envision it to be similar to the Drivers on the BF&P tool, where it’s like a spreadsheet that can be referenced and continually updated. I know there are ways to use Transform Columns currently, but a more intuitive way for the most technological-illiterate administrator (like I can be ) to create new columns/dimensions would be nice.
The “Driver” tab could theoretically live right in the data items area where I currently dropped my market breakout. Perhaps the data itself would show just as the existing data items, but the columns/data itself are managed in a pop-up screen:
Any thoughts on this?