Yes, we use weblogic user to create reports & dashboards and use the same user for migrations. If that is the case is it possible for us to create another user with admin access similar to weblogic and use that user to create those specific reports & dashboards.. Thanks !

Hi, I used the same but it is just giving only 2 days instead of the whole week But with this filters will this change dynamically everytime ? because whenever the user logins they wanted to see current week and further data only Thanks !

Hi, From subject area means ? What actually do i need to give here. I am planning to create a dynamic variable based on this SQL. Can I do that ? It is saying TIMESTAMPADD invalid identifier Thanks !

Hi, How can I apply filter ? Because whenever the user runs the report it should display only that current week and after that but no anything before the SYSDATE.. Thanks !

Calendar_Week is a varchar column

employee _name is coming from W_PA_Hrs table only..there is no other table with employee information. and both W_PA_HRS & W_PLAN_TIME tables are fact tables.. there is no join relation between those tables in physical layer..they are 2 seperate tables..In BMM I have created one fact W_TIME_F and added these two tables as…

Even if do a group by or not as soon as I add employee name into the report is giving me the wrong result for plan hours. Actual hours are still correct even after adding the employee name..only problem with plan hours.. Even if I add the employee name my plan hours and actual hours should still remain the same.. am I…

Hi Christian, That's what I figured out and now I have separated the attributes from my facts and created as dimensions in BMM layer and have set up the content also..at least now I am able to see the data..but looks like it is giving wrong values.

Hi Christian, Please see the below. Am I missing anything else..Please help me out.. In Physical layer they are two seperate fact tables..In BMM layer are created one fact table and added as LTS.. Thanks !

Hi Christian, we are having this employee name in one of the fact table and this column doesn't exist in any other dimension tables also..based on the join conditions I just modeled in the rpd.. when you say content levels for fact tables is it aggregation content group by ? is that where we set the content levels ? Thanks…

Agreed Christian. What are the options that we have now so that I can suggest our team in proceeding further on this. Appreciate all your help Christian:)

Hi Christian, Yes, the SQL in the view is retrieving the right results only.but when it comes to OBIEE the grain of the data is changing and also it is taking lot of time to retrieve the results..the performance is very bad..

Yes, I have set the content for all LTS in fact. I am having another issue now.. without adding columns from HRS view the report looks as below which is correct. when I add the column from HRS view it is duplicating the rows..Why is this happening.Sorry Christian if I am aksing silly questions..Please don't mind. Why this…

Hi Christian, HRS is the OBIEE view created in physical layer and it has joins with W_PLAN_TIME & W_PA_HRS. So is the reason in BMM layer I added in LTS. Thanks !

Hi Christian, I have the fact joined to the dimension in both physical & BMM layer..Please see the below..Am I missing anything.. This is the Business diagram.. Please help me with suggestions..Thank you !!

Hi Christian, I have set up the LTS content but that is not working..View is created in OBIEE . In physical layer I am not giving any join conditions. In BMM layer I have added in LTS to my existing fact table. I tried giving join conditions in physical layer .But the joins are not making any difference.I don't know if I…

Hi Gianni, I have one more doubt.I have added a new view to my existing model. When I just use the columns from that view it is giving data..But when I combine the columns of that view with the other columns from other tables the data from that view columns are becoming null.Why is this happening ? Any suggestions please.…

Thanks Christian & Gianni, One more question similar to this.. There is another SQl logic which needs to be implemented in OBIEE. How can the below SQL be transformed.. SELECT T.PROJECT_NAME, T.TASK_NAME, T.EMPLOYEE_NAME, T.ENDING_DATE, T.HRS, SUM(T.HRS) ACTUAL, 0 FORECAST, 'A' STATUS, (select SUM(T1.HRS) FROM…

Hi Gianni, Please see the below . I think the same SQL logic is already implemented right? so whatever hours we pick from dw_plan_time and dw_pa_hrs tables satisfy that SQL condition ? Am I missing something ?

Everything will be in one new logical column right ? Thanks !