If you set separate presentation variables with your page prompts and filter your analyses on them, the unwanted cross-page interaction will stop. I'm not sure how that fits with your "page # 4 analysis invokes an analysis from page level # 2" interaction, however.

Does your target page hold another OBI analysis? The action link would only require that the target be filtered on "Project ID". In this example, I've got an action link on "Title" that sends "PIN" to another page. The target page is filtered on PIN, but PIN isn't required in the output. Am I missing your point? The Action…

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.