We have drill-through capability in SmartView, which pulls data from our SQL environment, however I cannot figure out how the order of the result set is actually determined. More importantly, is there a way to determine the order of the rows that are retrieved? For example, if someone drills-through on a level 1 in the account dimension, how can I ensure that the resulting drill-through report shows transactions for level 0 accounts by alphabetical order?
Thank you for your help!
you'll need to provide a bit more detail about the specifics of your drillthrough function. Drillthrough to transactions isn't really 'default' functionality - so there are many different variations of it including;
- essbase studio
- other custom builds
specifically you're talking about the report formatting - so we'll need a lot more info to provide answers