OK, Now I have 3 tables, one of them is a date table that has a bunch of dates from help above including month and year. The other two tables contain employee id and one contains each employee ids hirer date and the other eachs termination date (null if not terminated.) How do I join these in the physical layer, what…

Hi Thomas, I see this sql code is in Oracle SQL. Do you know where I would paste it to generate the date dimension. Would I just need to make an oracle database and bring it into the physical layer?

Hi Gianni, Basically we have two tables, one with employee ids and hire data and one with employee ids and termination date. What we don't have is a table with a time dimension. What would be a recommended path to do what we suggested a monthly employee count trend? Thanks!

Hi Gianni Ceresa, I don't see the S_ETL_Day in the sys schema on my system. Why is that important? How would you recommend geeting an employee count by month including when nothing changed.

Just a Table containing dates. I've just made one and am experimenting and bringing into the repository. Is that how you would do something like I described above>

I'd kind of agree with you but these are all financial essbase BSO cubes. We can flatten the cubes and this gives us 1000's of measures which is not a best practice from what I've read for bringing into the analysis layer and makes the analysis slow. I'm not sure how to do a much smaller segment of measures based off of…

We have one measure called "measure". "income" and "gallons" are two accounts of the account dimension that gives the column header in the pivot table. The rows are given by the company dimension. The calculated item I did in the selection steps divides "income" by "gallon" income has a $ format while gallon doesn't. I'd…

Hi Gianni, I don't suppose you would know how to change the format of that new calculated item in the pivot table?

It might be a little different in 12c though. I went to selection steps and clicked on the dimension thats the column in my pivot atbale and add a calculated item that was the first column of the dimension in my table divided by the second.

Ha you beat me to it Gianni! I did actually find this out on my own exploring the selection steps just a bit ago but you posted it. Thanks!

The tutorial is helpful but shows how to do a percent based on a column in the pivot table. How would one do a calculation based on two columns in a pivot table (one measure that is calculated for the row dimension and the column dimension?)

Gotcha, I'll take the post down in the other discussion. I meant to edit and change to the enterprise one as that is where I've asked a few questions before.

Thanks Gianni, After talking with someone that has access to smartview about what is necessary to pass to get data (had to specific several dimensions) then we were able to see some data.

This is correct but now I have a new problem. The account values for the 5 account level 4 are negative. How would I go about changing them to positive and still have them display in the chart. I tried making a new calculated item that is 0- 'the account name' forthe 5 accounts in the level 4 and that seems to work but…