This is where you ask leadership for support in training you to do the job correctly -- or they pay an expert to come in and fix it while you shadow them. Currently, it looks like you have little or no management/leadership support OR you haven't pulled the help-chain enough for them to know you need this support. You've…

Fact Stars have the fact table at the center ... a conformed dimension is one in which it's primary key is found in more than one fact ... time and products below are conformed ... I can directly relate sales and purchases for the same date and/or product. I can get sales for any product purchased from a supplier…

+1 @Christian Berg Depends: Where are you at? When do you need it? On-site or remote?

Doing this in the front end is not going to get you far ... you need a proper design where you have the text and you can set that logical column's sort based on the numerical representation of the same.

You need the week number and day of the week number in your time dimension ... then you can give your client day-to-day comparisons (Monday to Monday across any time frame) AND date-to-date (5/16/2016 - 30 days). Also a well-formed date dimension has indicators for workday and/or weekend ... so proper calculations for…

Hyperlink color is the function of the browser ... not an OBIEE feature.

To restyle/reskin/customize the UI, follow the documentation ... then you can make changes to the custom skin such as: https://shivabizint.wordpress.com/2011/04/17/setting-default-graph-series-colors-in-obiee-11g/

Cesar ... the request is for a different calculation formula on the subtotal row than what is on the detail rows ...

These are two different measures.

then it's time to take a look at the RPD ... specifically content levels ...

Did you try deploying via the command line? not a solution to the wpage issue, but rather making sure it's not a server issue.

Java version might be the issue ... http://javarevisited.blogspot.com/2015/05/fixing-unsupported-majorminor-version.html

could be data types ... or the formatting of the date ... looks like your data has year as YY and prompt has YYYY ... if it is doing a text based comparison - then YY != YYYY ...

? each row is: Revenue*units/sum(units) subtotal is: Revenue*units/sum(revenue)

If you have the day key in your day dimension for the previous day ... you can alias your fact for previous day ... then via your model you can have current and yesterday measure and then do the variance and % change. You can also do this via time-series functions in the RPD if you have a properly formed chronological…

This running from a subject area in your RPD or direct SQL? ORA-00937 Error ORA-00937 occurs when the GROUP BY command is improperly used. The GROUP BY command allows the user to view rows having a common field value in a single row. For example, a small business CEO wants to view employees who worked the highest number of…

http://www.oracle.com/technetwork/middleware/bi/customizing-oracle-biee-11g-176387.pdf

Something like ... 'The Report above is for ' || CASE WHEN '@{FY}' <> '' THEN '@{FY} results for ' ELSE '' END || CASE WHEN '@{Program Name} <> '' THEN '@{Program Name} Program in ' || @{Region} ELSE '' END

For DW design - minimize null values in your fact tables and based on use of information (your specific case) don't skip rows at the granular level. So in ETL/ELT where a certain measure doesn't apply to the grain - write in the zero row ... only do it for the fact tables that need to support that type of use. Your case…

Anything in this archived thread of help? Connecting OBIEE to Redshift