Search results for query: *

Hello, I am trying to check the last 5 values of a column for each employee and if they match then i want to show that value, if they don't match, i want to show the most recent value. thanks in advance! D

Hello there and thank you in advance. I am trying to populate a column (week_number) in my employee table. I need to insert a 1 at the first entry_date and then increment by 1 for every entry_date after, in sequence for EACH employee. The issue is, each employee can have a different entry_date...

i need to find out the difference between sequential week numbers and store the value on the current weeks row. How can i do this is a view. I have id, shipped and week number columns as shown here, I need to get the 'desired value' column to use as a denominator. Any ideas? Great thanks in...

Is there a way to transpose data in Excel as in the example below? the id column i would like to repeat down the rows and the corresponding rec_ids listed out instead of the comma separated values. data as it stands in Excel here is what I want in Excel thanks, D

I have two data sets in a report document. R1) Date attribute with a metric value of sysdate()-1 which shows up as 20120626 for today R2) Date attribute with a metric value of maxExecutionDate which shows up as 20120625 for today What i am trying to do is create some conditional format to...

Is is possible to create a report to show the top 5 customers in sales individually and the remaining customers grouped into 'Other' or 'everyone else'? Point me in the right direction Thanks, d

Hello All, I am trying to format a cell to be a certain color and have a double line border at the top of the cell if the value of another cell is ='Total'. I have tried conditional formatting but there are only single line borders. Here is the code that is generated when I record a macro to...

Hello All, I am trying to format a cell to be a certain color and have a double line border at the top of the cell if the value of another cell is ='Total'. I have tried conditional formatting but there are only single line borders.. thanks so much in advance. dinzana

In Desktop it is possible to force data to export to a specific Excel file, which allows me to format a nice reporting workbook etc. Is it possible to do this from the Web Interface? Thanks in advance. -dinzana

Hello All, Has anyone run into an issue where a nested prompt that works properly in Desktop is NOT working when executed in MSTR Web? What the???????? Is this some sort of bug? I am using version 8.0.2 Thanks in advance, -dinzana

Hello All, Thanks in advance for your help. What is the following line of code trying to do? translate(substr(<columnName>, instr(<columnName>, , '|', 1, 1)+1, instr(<columnName>, , '|', 1, 1)+1), '_0123456789','_') Thanks again! -dinzana

This is very much a continuation of a previous thread (thread183-1365652), I am so sorry, but I am stuck. I now have a table with the below data and I am trying to get the resultset listed beneath. The previous thread did not have accountId in the mix, so it gets a bit more complicated. You...

Here is a sample of the source data table GotIt startDt endDt Amt 01/01/2007 04/04/2007 100 02/02/2007 04/04/2007 150 03/03/2007 04/04/2007 250 I am trying to get the data into a temp table to show the date range and amount represented in that range as shown...

Hello All and thank you in advance for your input. I am trying to update the tblDailyTEST table (dailyAmount column)with the appropriate value from the tblRunningAmount table using SQL. Any ideas? the resultant table is the third example below. thanks again! tblRunningAmount accountId...

I need to change the location of the data files for a database. We are running out of disk space on the c: drive of the SQL Server. My questions are: 1. How is this done? 2. Are there any caveats to this as I have several SSIS packages that are pointing to this particular database? Thanks...

I need to change the location of the data files for a database. We are running out of disk space on the c: drive of the SQL Server. My questions are: 1. How is this done? 2. Are there any caveats to this as I have several SSIS packages that are pointing to this particular database? Thanks...

Thanks for checking this thread. Division is an attribute that belongs to the following hierarchy structure. Parent to Child repectively Chain > Division > Group > Department > etc.... I have 2 metrics -Sales = (sum(sales), dimensionality Report Level) -Sales for Total Group =...

Any ideas on how can I use MSTR to calculate the number of weeks i had inventory supply for. Week 1, I had 100 units on hand, I sold 50 of those units and did not recieve any from the factory, Week 2, I had 50 units on hand, I sold 25 of those units and did not recieve any from the factory...

Hello All, We have to servers (D and U). They are identical. We are developing using the Toad tool. On the D server we all have access to view, and change all of the tables, packages, functions, and stored procedure code. On server U we would only like to VIEW the code behind these objects...

Hello All, Is it possible to grant a user &quot;read only access&quot; to stored procedures / packages / functions? Thanks for your time. dinzana