The column should appear under conditional formatting by whichever name is currently selected in the Col Selector. The Col Selector takes a little practice to get familiar with, but it's a pretty powerful tool for the right task. I hope I didn't lead you into a blind alley. This was just one way I could think of to get…

The column selector has to be built, and it will only accept existing columns from your model. * Start by adding a new column to your query. * Open the Add a new view/Column Selector * Under your new column, check the "Include Selector" box * Double-click or drag columns from your model into the selector * Then, you can…

One specific solution that may not fit your situation, is to use a Column Selector as one of your dimensions (instead of a dashboard prompt). In the two examples shown below, I'm using a column selector to control the row dimension in the pivot table. That enables me to place a Conditional format on all values of "Light…

Hi SonPat99, This may be irrelevant to the preceding discussion, because I'm only familiar with using EVALUATE with SQL server functions, but your original statement has no ELSE clause in it. That would also lead to a blank record. Jerry

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