Actually it's you that still need to answer 2 of his questions: expected workload and the kind of reports you expect (as you have the definition in the reply of Manoj). And also keep in mind we all have a life and a work next to the forum, so having to wait a day for an answer isn't that much in the end (or the only other…

Hi Ali, For your "question2" keep answering to the thread as you have the right people on it to give you the answer (rmoff for example).

Hi, I would say that it depends, it's not really a YES or NO answer ... If you want to make analysis on your full population of customers all the time (and not miss those without transactions) creating FACT rows for all of them will make your life easier. If on the other hand you mainly do analysis on customers with…

If there is one or 2 of these things that still keep being on screen and can't find which privilege manage it just post back here If you got everything you were looking for also consider closing the thread.

Hi, Go into Administration > Manage Privileges and set your security correctly. Setting the security and customize based on your need is supposed to be one of the first things you do. You can hide most of these things for the consumer application role, but can't hide it completely as there are things like the "signed in…

Well, in theory yes, they are supposed to be there. But again: they aren't really important as these groups are just mapped into application roles, and the default security is setup on the application roles. Is it a clean fresh install? Everything went fine or had some issues?

And what is the history of that install? Is it new? Is it a old one? Because by default on a 11.1.1.7 install you end up with the few groups. But it isn't mandatory as they are just there as example .... As long as you have the application roles everything is fine.

Good that you found your solution, can you please close the thread and mark @Manoj Dixit as correct? It will help others with same/similar question knowing there is a valid answer in here, right now it's still This question is Not Answered.

Hi, Would be cool if at least you provide your version and what you did to end up there (new install? One day you went to the office and it was like that?). Just a detail: if you look for BIAuthors, BIConsumers and BIAdministrators under the groups they aren't users but groups, call things with their name, it will help…

I'm almost sure you must have some logs .... (Did it really take 639 minutes before to fail? Is your server really up? Because I never heard of an OBIEE install taking 10 hours !)

Hi, Please don't double post: These 2 spaces have the same users in the end, so double posting you are just creating threads having independent life and not followed in the same way. More in general double posting receive less attention ...

Hi, First better to call it Fact or Fact table but not Fact dimension as these are the 2 things you have in a BMM: facts and dimensions (so it can't be both in the same time). In the BMM a fact logical table is mandatory, but the presentation layer is just about presentation. So there is nothing mandatory, you can also put…

Similar as before, you model your tables making the joins based on your conditions between xxesc_pa_timecards and xxesc_forecast_time, for the "Total_Actual" you can add a "by" in the formula.

Hi, Your SQL can't be used in the RPD just because if you use it you are making the whole concept of RPD useless (and paying an OBIEE license when SQL Developer could do the same for free). Yours is probably the most simple model you can have: dw_project_d is conformed dimension and dw_plan_time and dw_pa_hrs are 2 fact…

And where is time spent? What does the system do when it's taking longer than 11g? These are the key element to understand what can be done to improve your current situation ... So start analyzing your logs to get these info.

Interesting, but it's definitely something at the browser level (the way I understand it). And as you did, deploying a copy of the JS file "locally" on the server, is always the way to go just to be sure of what the library does (guess what happen if the D3 site is hacked and their library takes your data from the page and…

Yes, you will have a single column in the logical layer and presentation layer (in the picture above it's the "Source" column, "Column A" is just there as random column returning some other data...

Hi Sam, Just to make sure, what kind of tutorial / blog / document are you following for the install? In case you don't have any have a look at https://realtrigeek.com/2016/04/15/installing-obiee-on-linux/ or also Installing OBIEE 12c. Part 1: Prerequisites - Red Stack Tech . Your log complains about some JDBC ... but not…

Hi, A grand total calculated automatically by OBIEE because you enable totals on your pivot will not allow you to do that as you don't have a place where to enter a formula for it. It's calculated automatically based on the aggregation rule set and not a custom hand written formula doing * 40 .

Hi, You seems to have the good model to solve this easily ... So you have 2 physical tables, going into 2 logical table source into the same logical table. Look at this picture, it's what you can try to do it. The idea is to add a new column in your logical table (in my picture it's the one named "Source"). This new column…