Hey Shane- Thanks for the tip. Unfortunately this doesn't seem to work. As you can see behind the settings .... my graph is still incorrect.

Yes, I would like to have the % values show up on the bars on the right. If they look weird I understand they will not show up...however is there at least a way for the user to hover over the bar and see the %'s?

Thanks so much!! Not sure how I missed that

Got it working by modifying some SQL: I create a union query that merged Net Other with the other categories: SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT saw_0,saw_1 FROM ((SELECT saw_0, SUM(MassiveT.saw_3) saw_1 FROM (SELECT saw_0, saw_1, saw_2, saw_3 FROM ((SELECT '1. 2018 Year End HC' saw_0, "Department…

Got it working. I was able to get the LSQL to work. Most likely an easier way to do it, but I'll take it: SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT saw_0,saw_1 FROM ((SELECT saw_0, SUM(MassiveT.saw_3) saw_1FROM (SELECT saw_0, saw_1, saw_2, saw_3FROM ((SELECT '1. 2018 Year End HC' saw_0, "Department…

UPDATE: I am able to get the data in a format that aggregates the data. Can someone please help me to make it the last mile. Here is the LSQL for this result. Now I believe I just need to be able to do the calculation in between the unions..... : LSQL: SET VARIABLE PREFERRED_CURRENCY='Local Currency'; SELECT Massive.saw_0,…

Hey Christian and Gianni - Thank you for your responses. After talking to some of my co-workers I believe we have HCM as the system of record and that feeds OTBI. The analytics tool looks like this if it helps: Another note on Net Other. I believe we certainly have data quality issues but the way the transactions occur…

Hey Gianni I had typed up a long response when the other thread was locked. Darn. I believe it is OBIEE in the cloud? That's 12c right? I have tried a number of different techniques that I will detail below in diagrams and Images. The main issue is that I am unable to get the results of what we call net other into a single…

Hey Jerry- That comment got me to the answer. I appreciate it: "Gregorian Calendar"."Date" = TIMESTAMPADD(SQL_TSI_DAY , -(1), TIMESTAMPADD(SQL_TSI_DAY , DAYOFMONTH(CURRENT_DATE) * -(1) + 1, CURRENT_DATE)) or more efficiently like Gianni TIMESTAMPADD(SQL_TSI_DAY , DAYOFMONTH(CURRENT_DATE) * -(1), CURRENT_DATE)

Hey Gianni- Thanks so much for taking the time to review my post. By it doesn't work I mean I get No Results. If I filter on the hard coded date 12/31/2018 I do get results. If I enter the expression in a formula I get the expected result. I don't have access to run to do any sort of debugging in the environment. However,…

Gianni, Thanks so much for your response. Just returning from vacation. Exporting as a CSV fixed the issue. Christian Berg, I try to everything I can in the tool itself. My OBIEE skillset isn't quite there yet, but that's why I'm here!! Trying to learn.

Robert & Asim, I don't have access to the ETL and can't provide the script to create tables.... However, by simply adding in the Date Dimension it fixed the duplicate issue. Thank you for taking the time to review my inquiry. I appreciate the assistance.

Thanks for the tip. When I use Date in the query it eliminates the duplicates. How simple! I hope I haven't wasted to much of your time! THANK YOU EVERYONE, PROBLEM SOLVED!!!

Asim, Unfortunately this does not work: “COUNT(DISTINCT "Position"."Position Description" By "Employee Attributes"."Employee Number", "Workforce Profile Event Fact Details"."Last Hire Date")”>1 Unfortunately, the above doesn’t work. It returns inconsistent results as well. It looks like it’s closer. The numbers returned in…

“COUNT(DISTINCT "Position"."Position Description" By "Employee Attributes"."Employee Number", "Workforce Profile Event Fact Details"."Last Hire Date")” Unfortunately, the above doesn’t work. It returns inconsistent results as well. It looks like it’s closer. The numbers returned in the columns are only 1, 2 or 3. This…

"Make sure you have server complex aggregate on this, a lot of the time the result of case statements fails because OBIEE tries to evaluate AFTER aggregation" How do I toggle this setting on? "Btw, the case statement was your addition, I actually meant to put this in columns and then reference one column in the condition…

Unfortunately, after I've changed the logic to just Max() and Min() as you suggested the Position Descriptions all come back the same. i.e. the case statement evaluates to 'Not a Duplicate' in every single row of data. Current Case Statement: CASE WHEN MIN("Position"."Position Description") <> MAX("Position"."Position…

Martin thanks for your reply as well! I tried your method: I put this in a calculated column to try help me understand the logic… COUNT("Employee Attributes"."Employee Number" By "Employee Attributes"."Employee Number", "Workforce Profile Event Fact Details"."Last Hire Date") Also I don’t quite understand what the by and…

I FEEL LIKE THIS ADDITIONAL INFORMATION MAY BE IMPORTANT: Sometimes there can be 3 rows for one Unique Employee ID / Hire Date Robert thanks for your reply! I tried your method: I was able to get MIN("Position"."Position Description") to work correctly. However when I try to use: MAX("Position"."Position Description")-2 I…

I can tell you that IT controls our ETL and I am in an Analytics Function. When we want changes we go to IT and then they draft up requirements etc..... I'm guessing the idea was it would be easier to base age on a static date. In the Subject Area I need to use now it's common for criteria to contain different time period…