Search results for query: *

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).

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"...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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