Gemini - Provide wizards for date and numeric grouping
It's taken me some time to get around to this one, but it's perhaps one of my most important suggestions to date. I've discussed the problem in the threads, but I'd like to formalize the suggestion.
One of the challenges that Gemini cube builders will face is the lack of grouping functionality in PivotTables. Grouping is a very common end user task. In SSAS, these tasks are usually handled by a date wizard in BIDS (for date groups) or through an attribute property setting in the cube development environment (for discretization). In Gemini, the user has to create a number of calculated fields to accomplish the grouping tasks. For the target Gemini users, creating these calculated fields could be challenging. Providing appropriate wizards would diminish or completely eliminate the challenges involved.
Upvotes: 0<=-=Aug 30 2009 1:02PM=-=>
Colin — thank you for this suggestion. It’s a very interesting idea and one that the team will consider.<=-=Oct 19 2009 3:58PM=-=>
Thanks again for the very detailed feedback. Providing wizard-based UIs to automate complex, common case scenario is an interesting idea that may find its way into our future releases. However, our very tight shcedule for Gemini V1 will unfortunately prevent us from doing this in the short term; as discussed, users will still be able to create calculated columns as a manual workaround for now.