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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.