Ok, so keeping it short: not really. And for sure not setting itself as "total" (as in general it's more the other way round and a normal default value would be the most detailed level of the hierarchy.

938767 wrote:... is quite time consuming. Well, knowing the RPD is a one-shot activity and so you have to do it only once I would not say it's wasted time but it just takes the time it's supposed to take. As you set it by default to TOTAL it means that most of the time your "new" dimension are non conformed dimensions. So…

Did you read the link posted by @rmoff ? Did you "debug" a bit your error? For example replace one of the 2 arguments with a different value to find out which one give you the error? But I guess it's the date... Because you write '1/1/1970 05:30:00 AM' assuming it's a date while that is just a varchar ... The link show a…

Hi Kumar, Please do not start adding random things like an index here or there because you are desperate, you will only make things worse and unpredictable for the future. First you must be sure of where the time is spent, as you post a SQL Developer screenshot I assume your analysis (…

Hi, The currently running queries can be viewed in the "Administration" page when you look at "Manage sessions". S_NQ_ACCT is for usage tracking (so stats) and data is inserted not only at the end of queries but in an asynchronous way, so a line can be inserted after some time the query was over.

Hi, If you create the dashboard by hand again in 12.2.1.2.0 I imagine everything works fine, right? Can you do that for one of your dashboard with the problem and then compare the "dashboard layout" file between the upgraded version and the one you created by hand? It's the file that exist inside the dashboard folder for…

First: search the forum, same topic coming every week ... The answer is always the same: where did you see that OBIEE run on Windows 10? Does the compatibility matrix confirm compatibility with Windows 10? No and no. OBIEE is a server product, Windows 10 is a consumer end-user workstation/laptop. So if it doesn't work ...…

Add a "filters" view to your analysis. In the same way as you add a chart, a table or a pivot in the "Results" tab you can add the "Filters" view.

The hierarchy is mandatory (I assume you have hierarchies for your other dimensions, right? So just add one for this new table as well: grand total and detail level right after, no need to use it or add it to the subject area). A business key can have as many column as you want (the max is all the column of the logical…

Yes you must add them into a logical table acting as a dimension. Worst case if you can't find a better business key just add all the columns to it...

Hi, I assume you have the attributes coming from the 2 fact tables in the logical fact table? If it's the case you have a problem with your model. In a dimension model the fact table must contains only measures, any attribute must be outside in a dimension. In your case it would be a degenerated dimension (that's how…

It would help if you posted at least your OBIEE version, things can be quite different if you are on a old 10g, a bit less old 11g or a current 12c. Look at SampleApp, it has examples for that (the code is provided) and it's the "best way to do it" (as it's Oracle telling you to do it like that ). Live example on Sample…

You must buy them! There is no free map officially from Oracle, all you have is the provided high level demo. As far as I know Oracle doesn't sell maps directly but other companies sell them (you can also use Google Map if you buy an API key). Look what Andrew posted... (or Google for it)

The separate use of a "normal" webserver is often used as simple proxy to give a nicer URL to your OBIEE (without port number), doing SSL offloading or caching CSS/JS/images to "improve performance". For this last need you must already have a super busy server (I mean lot of concurrent users etc.). For the first need it's…

Well, it's not completely wrong: as said you can open with a newer admin tool a older RPD, but you can't save it as the old version. As soon as you save the RPD is "upgraded" to the Admin tool version. So open yes, save no.

Opening and making changing it's fine, just do not save or your BI server will not start anymore ... Never ever try to use mismatching server and Admin tool versions. Yes, there are people who will tell you that there is a way to downgrade the RPD etc., but why to look for issues when you can have many admin tools of…

If you open your group while in the "Result" tab of Answers and save it the group will be saved as expanded and when you open the analysis the group will be open. That's also the reason why you must never "play" with your analysis in the "Result" tab when testing but only in preview as what you do there will be saved in…

Hi, A quick one: did you unchecked "suppress" and select "repeat" in "Column properties" > "Column format" > "Value suppression". As you say in the physical query there is no distinct it means the physical query return the duplicate? Then it's only the analysis hiding it (that's why I point first to the "suppress"...

You got the "technical" answers already, so I would like to give you my point of view on the "requirement". Abdul Kather Jeelan wrote:... a requirement where we need to send a report as mail to a Manager email ID in 'TO' and Deputy Manager ID in 'CC' That's not a requirement but somebody whining on a fake requirement.…

Hi, As far as I remember 11g (don't have one in front of me right now) it's not something you can manage in the UI and for sure (I would say) not a per prompt setting where it's available for few and disabled for others. Your problem I would first say it would be better solved by design: have a different design of your…