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!

  • Congratulations TouchToneTommy 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: *

  • Users: jonhoward
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. jonhoward

    Tab delimited file from Narrowcaster

    Has anyone customised Narrowcaster v7.x to deliver tab-delimited csv files? TIA for any help
  6. 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...
  7. jonhoward

    Drill from Report Builder A to Report Builder B

    Is it possible to drill from one report builder to another? Report Builder A has object prompts for Attributes(Rows), Attributes(Columns) and Metrics. User chooses what they want on the report and runs it. Then they want to take a subset of that data and drill across to another Report Builder...

Part and Inventory Search

Back
Top