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 Rhinorhino 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. jonhoward

    Use of Wildcard in Attribute Qualification?

    Hmmm... I wonder also (it's a slow afternoon!) if you could write a piece of freeform SQL in MSTR and use the resultant report as a filter for a second report (so Report As Filter).
  2. jonhoward

    Use of Wildcard in Attribute Qualification?

    You could use Command Manager to build the filters? Much easier for mass object creation... bit of messing round in notepad to get the list first then use Command Manager to run your script. Will look something like CREATE FILTER "Bill Topping" IN FOLDER "\Public Objects\Filters\TekTips"...
  3. jonhoward

    Use of Wildcard in Attribute Qualification?

    I don't think in a SQL IN 'xyz' statement you can have wildcards. If it's IN then it is a literal string. Depending on the size of your list, use LIKE *Bill Topping* Unfortunately this means each entry in your list would have to be done seperately. Make the filter operators OR and you'll end...
  4. jonhoward

    User Interfaces for MicroStrategy?

    You need to tell us what kinds of things the users *actually* want to do, and then we can help assess how much can be done through Web. Of course "power user customers want to do everything under the sun with the data", that's what users always want - to do anything and everything, with anything...
  5. jonhoward

    User Interfaces for MicroStrategy?

    MSTR Desktop is the full fat client server interface and as such is not browser based. Basically, the interface to MSTR through a browser can look like anything you want. It's completely customisable, if that's what you want to do. Personally I try and avoid doing too much unless absolutely...
  6. jonhoward

    7.2.2 - Drills across a M2M - aghghghghghgh!!!!!!

    Might be going down the wrong route with this but what's the DSS Star Join VLDB setting for the report / project?
  7. jonhoward

    Custom Date/Time formatting

    This should be so simple..... I have a base metric Sum(seconds) I have a metric to convert this figure to a timestamp (Sum(seconds) / (60*60*24)), with dd"d"hh"h"mm"m"ss"s" as the Custom format If the number of seconds equates to greater than a day, then the time is displayed correctly...
  8. jonhoward

    Synchronising projects

    I have 2 projects DEV and LIVE. There are objects in DEV that are newer than in LIVE, which is expected since development work is ongoing. However there are objects in LIVE that are newer than in DEV, and this is not good because it means objects have been built in LIVE and not gone through the...
  9. jonhoward

    Upgrading from v724 to v754 or v8?

    Freeform SQL - architect can create logical views in the schema, so no more pleading with DBA's for database changes; and you can map freeform sql to attributes, metrics and reports. Closer integration with data mining models (importing using PMML) looks interesting. Readme is TN5800-800-0569...
  10. jonhoward

    Insert text value into a column

    Actually, I've worked it out already. The text prompt is set up in the same way as using a number prompt....except that there is a bug in MSTR that prevents you from seeing prompts other than Number and Long in the objects window, and stops you from dragging and dropping it into the metric...
  11. jonhoward

    Insert text value into a column

    It's possible to have a prompted metric in a report that allows the user to enter a number and have that number populate a complete column in the result set. TN5700-751-1227 has the details. I want to be able to do the same thing but with text. Does anyone have any ideas, or alternative...
  12. jonhoward

    Listing Reports

    Run a search for metrics that have € in the name (assuming that's your condition). Then shift-click the results (select all) and RMC to choose Search for dependents, changing the Object Types to Prompts. You should now have a list of all prompts where there is a metric with € in the name...
  13. jonhoward

    Column Type displayed different in Backened and MSTR Warehouse catalog

    Looking at your SQL, and guessing from the naming conventions, are you creating a view of a view? I have a similar issue in SQL Server 2000. My example would be as follows: the base table has a column of datatype Char; the first view is a straightforward SELECT from the table, and this view...
  14. jonhoward

    SQL Server ODBC error

    Does the table exist in the metadata? If no, then your metadata is broken, or you're trying to connect to the 'wrong' database. If yes, check who the owner of the table is (no doubt the rest of the metadata tables will have the same owner).It's possible the owner of the tables isn't referenced...
  15. jonhoward

    ApplyComparison help

    Report is supposed to allow the user to choose a period, then present data for any subsequent periods in the warehouse. For example, if the user chooses October 2002, the end results should show data for November 2002, December 2002, January 2003 etc etc etc. ============== SQL being generated...
  16. jonhoward

    Tab delimited file from Narrowcaster

    Has anyone customised Narrowcaster v7.x to deliver tab-delimited csv files? TIA for any help
  17. jonhoward

    prompt-in-prompt ?? Is there a limit???

    Haven't done it myself, but the MSTR Practical Usage for 7 document states: Number of dependent prompts in a given report - Prompt in Prompt per server practical limit 5 max tested 5 (This document is from May 2002, so may well be out of date (max 5 vs. unlimited?) but it is the only I know of...
  18. jonhoward

    Calendar DATE vs database DATETIME

    Thanks for the pointers. I'm now using the following ApplySimple("trunc(#0)", DATE_ATTRIBUTE)
  19. jonhoward

    Calendar DATE vs database DATETIME

    MSTR 7.2.3, Oracle I have an attribute (A) with a DATETIME format in the warehouse (so format is dd/mm/yyyy hh:mm:ss) If I build a prompt in Web I can use the calendar, but the SQL generated will have a clause along the lines of... ...where A = 31/01/1999 But the data in the warehouse will...
  20. jonhoward

    Problem with the results of a report

    What if you were to use the fact table as the lookup for Month? TN4000-7X0-0833 has some extra info

Part and Inventory Search

Back
Top