Hi Cameron, In the Criteria tab, when you hover your cursor over the header, do you not see a 4-way arrow? When you do, you can click-and-drag the header into the correct position. That's what I was referring to above, about the header for your added column. You have to do that to get the header for an added column (in the…

What you describe sounds like the filters could conflict. You can use two separate "formula filters" (not sure what they are officially called) on the same measure in two separate columns. By that I mean the FILTER function available within the column formula editor. In your case, you can have one column: FILTER(MeasureA…

Those columns are written as part of the analysis. The saw_x syntax allows you to reference the columns of the union without typing out the column formulas (which may differ from one leg of the union to another, anyway). "saw_o" is the first column on the left, then they're sequentially numbered to the right. It's actually…

Sanity would put me out of a job

Hi Cameron, That's a message I've seen many times. When you add a new column to the component parts of a union, the header for the new column appears in the right-most position, outside the calculated "Results" columns. You then have to move that header to the inside of the "Results" columns that contain the "saw_" syntax.…

If your main concern is the dashboard space the results consume, the "Fixed header with scrolling content" option allows all of the results to be viewed in a fixed-size window.

If you are prompting your detail report on the 5 columns that Robert Angel mentioned, you will only get the records with the Supervisor of the particular "10:00:00 AM" that you click on. Have you carried too many filters into your drill report?

The quick way is to place your "Exceeded/Not exceeded" column into the table prompt area. If you want to go further, select the "New Calculated item..." on the column options, choose the "Exceeded" value, name it, then "Hide Details"/ "in current view" options.

I do understand, as far as I can without having answered the 10,000 questions that you have. Just to clarify when I might use the method I offered: OBIEE is very effective at doing analytics on project schedules on a mass scale (much better than our scheduling software). I use data models that contain 90+ date fields,…

HI Christian and Thomas, I completely understand what your saying about proper modeling of the data. Many of us aren't involved in model building and are trying to meet expectations with what we have to work with. If one of the hacky workarounds that I've used in the past answers someone's question, should I refrain from…

This one gets you the last 12 months, based on the first day of current month. "Your Datefield" BETWEEN TIMESTAMPADD(SQL_TSI_MONTH,-12,TIMESTAMPADD(SQL_TSI_DAY,-(DAYOFMONTH(CURRENT_DATE)-1),CURRENT_DATE)) AND TIMESTAMPADD(SQL_TSI_DAY,-(DAYOFMONTH(CURRENT_DATE)),CURRENT_DATE) You can replace the bolded text with…

To combine your original idea with Robert's, use a variable prompt with radio buttons for Yes and No that sets a presentation variable, say "varExclude". in your query filter, include lines like this: 'Yes'='@{varExclude}{No}' AND [Filter that excludes outliers] OR 'No'='@{varExclude}{No}' AND ID NOT NULL (or whatever)

"Gregorian Calendar"."Date" = TIMESTAMPADD(SQL_TSI_DAY , -(1), TIMESTAMPADD(SQL_TSI_DAY , DAYOFMONTH("Gregorian Calendar"."Date") * -(1) + 1, "Gregorian Calendar"."Date")) You need to replace "Gregorian Calendar"."Date" with CURRENT_DATE on the right side of the equation.

I should have added that I work in version 11.1.1.9.5. I'm assuming the prompt editor looks the same for you.

To get this: I used a single field called "Image Date", and created 3 column prompts like this: When you create each prompt, select "column prompt", choose your date field, then use the edit button in the top line, shown below to change it to Year(Datefield) or Month(Datefield). "Month" is shown below, and the second…

Are these prompts on the same page? Do you have a time dimension set up in the data model? If so, put them in the same prompt and constrain month by the year prompt, and date by the first two. If it's across different pages and data models, use presentation variables where you have "???".

Hi, This was just answered yesterday: 4191248 The gist of it is, when using an action link to pass multiple filters, use the "Navigate to a web page" option, not the "Navigate to BI content" option.

Hi "3267774", Robert has already given you the correct answer, and you should mark his answer as such. (I'm not fishing for his points) I just wanted to point out that when you add the action link to the Services column, use the "Navigate to a Web Page" option, not the "Navigate to BI Content". Place your Report B on a…

Hi all, If the analysis is as simple as the one pictured, you can "fake it" with a conditional column and a pivot table. In this example, the "Measure Labels" are hidden.

Hi Farruhk, I'm not aware of a method to do specifically what you've described, but I'm not one of the gurus on here. I missed the fact that you were sending a dashboard, and not just an analysis. Have you considered using a hidden dashboard for the agent? Then, you could set the prompt defaults to values like the ones I…