Management nightmare ...

+1 to @Gianni Ceresa nice simple ... basically a minus query ... Catalog MINUS Used ...

True ... actually a well formed date (calendar) dimension takes care of this issue once and for all ...

Simply build a logical column that evaluates the actual date physical column ... no need to then be casting and concatenating -- let the database handle the data! CASE WHEN to_char("Personal Information"."Last Hire Date",'DDD') between to_char(sysdate,'DDD') and to_char(sysdate+30,'DDD') THEN 'Y' ELSE 'N' END DDD - is day…

Create a custom portal and consume the dashboard objects into it ...

"The reason for this is that they have a very large pivot table (where they want all the available information to be kept), but the scroll bar is the far right and when they scroll they lose focus of which row they were initially looking at." That's the issue ... I don't believe you can move the scroll-bar ... you need to…

Wrong tool ... BI Publisher can burst reports.

Why not have publicly facing presentation server and allow the vendor/supplier to get their own data & analyses? ... not too hard to give them each a login and filtering data based on that login.

Use the database to do this -- it's much better at it ... here's a few ways to do it... Three Ways To Transpose Rows Into Columns in Oracle SQL - OracleCoder

that's the difference between what @Gianni Ceresa posted and what th OP has ... good eye!

NTILE won't do what you are looking for, but PERCENTILE should ... what answer are you getting with PERCENTILE? It may be that it is counting the zeroes

Don't double post ... you've already got a post in the BI Publisher forum.

My suggestion: 1. Date dimension 2. Hour Bucket dimension 3. Fact table grain: shop, date, hour bucket Fact measure: duration in hours ^ then model in RPD

Your yellow line is YTD measure (level-based at Total Product) ... as has been said this isn't how a pivot table works. Can you show the YTD value by month? absolutely! A teeny bit of modeling and you'l have it. Whomever mocked up that grid needs a little more knowledge of how the tool works before accepting requirements…

1. Properly formed calendar dimension with LY keys on row 2. Alias your fact and join dates on LY keys in Calendar Now you have canonical time and 2 logical facts to work with Current Year and Last Year ... Your question is similar to: Canonical Time set up for a fact. error OBIEE 12c take a look here and post back with…

SERVICE_NAME = MYSID SID is not the same as Service Name ....

do you get data from the view in SQL Developer/SQLPlus?

+1 @Christian Berg You are always going to trade flexibility for performance and vice versa. Do the binning in your EDW - then the bins can't change without a 'restart'- performance is great but is terribly inflexible Do the binning out in the presentation server at run-time - get dynamic bins - highly flexible, but…

1. After implementing MUDE, if 3 different Users (User1, User2 & User3) are working in 3 different projects in RPD, all 3 User's changes will be published. -- not necessarily; you don't have to publish the MUD master RPD to the server 2. If I want to move only User1 & User2's projects to higher environments like…

read the document ... unzip the first one only and then import the appliance into virtual box ...