Tag Archives: Object Prompt

Trick to sort on attributes inside Object Prompt

Engine, Prompt,

This is an old trick concerning sorting in reports and templates.
Let’s say your report uses an object prompt containing a number of attributes and you want the results to be ordered by those attributes. If you simply go to the ‘Advanced Sorting’ menu you will see that the attributes are not there, obviously because they are not part of the report itself.

Here comes the trick. Just add the attributes to the report, define the sorting and then remove them. Go again into the ‘Advanced Sorting’ menu and you will see that they are still there. Neat!

So now, when you execute the report and select your attributes from the object prompt in any combination, the Analytical Engine will know how to deal with them. Even if you play with the position of the attributes (rows, columns or page-by) the sorting options will be maintained.

Object Prompt in RS Document

MicroStrategy, Prompt,

Have you ever checked placing a report with object prompt in report service document? if so, then the object prompt won’t appear in document.

Tips:

  1. Place all the attributes (which present in object prompt) in to the report
  2. Add as a data set into report service document.
  3. Drag and drop the report(grid) into the document.
  4. Save and close the document.
  5. Open the report, remove all the attributes and place the object prompt into the same place (column or row) where attributes are placed.
  6. Save and close the report.
  7. Now, execute the document.

No wonder, it will ask you to select the attributes from the list.