Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mrdalton

    Where is the SQL for a report stored?

    I'm running into a situation where I need to have access to the SQL of any given report after report execution. It has to be somewhere in the system, as I can see it by looking at report details. Is there a table in the meta data or a file somewhere that holds all the information you see when...
  2. mrdalton

    Using ID Attribute Form as column in SQL WHERE clause

    Thanks again for the excellent feedback on this issue. If I understand correctly, MSTR does not make the translation from the description selected in the filter to the ID stored in the database when doing the SQL? If this assumption is correct, is it possible to display both attribute forms on...
  3. mrdalton

    Attribute Form Sorting

    Gregg, I thought about that, but indexing a text field is sort of bothersome and could eat up quite a lot of space in the DB. I'd like to get the ID thing sorted out before we go down that route. Have you had any luck with your problem? Mark
  4. mrdalton

    Using ID Attribute Form as column in SQL WHERE clause

    Thanks for the quick reply. I agree that something smells fishy; MSTR does use the ID's by default when it does the joining, but when I add a pre-defined filter, the SQL WHERE clause uses the description. For example, I have a report that generates a simple count of users by region. My report...
  5. mrdalton

    Using ID Attribute Form as column in SQL WHERE clause

    Does anyone know how to change Microstrategy so that it uses the ID form of an attribute rather than the Description form when generating and executing the SQL? I have attributes set up with a 'Number' or ID form (1,2,3) and a 'Description' form ('USA','Canada'). My problem is that the SQL...
  6. mrdalton

    Attribute Form Sorting

    Hi Gregg, I'm having a similar issue with forms in Microstrategy, except that my problem is with selecting rather than sorting. I have attributes set up very similar to you, with a 'Number' or ID form (1,2,3) and a 'Description' form ('USA','Canada'). My problem is that the SQL that is...
  7. mrdalton

    Dynamic Table Names in DataMart Report

    Is it possible to prompt a user for the name of the table to be created in the context of a DataMart report? Our company has a need to dump the results of reports into our relational database, but having some kind of control over the names of the tables would be very helpful. I assume one...

Part and Inventory Search

Back
Top