Create Dynamic variables in RPD with required Dates (CurrentDate : Sysdate) and pass the variable in Prompt as default value.

I have reverted to sample RPD but not able to login to OBIEE application, and also deployed Empty Repository still the same issue.

Thank you all for the solutions and explanations . i have tried one option associating user to BI Consumers Application role and removed 'authenticated user' from BI Consumers, it is working fine. but i think restricting users with Separate Group in Windows active directory is best practice.

Following is the error in sawlog. [2017-04-06T13:29:01+05:30] [OBIPS] [ERROR:31] [] [saw.rpc.server.responder] [ecid: ] [tid: 11244] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] An error occurred retrieving DMS metrics.[[ File:dmsmetricstream.cpp Line:65 Location: saw.rpc.server.responder saw.rpc.server…

Version 12.2.1.0. yes i have restated all the Services ,even i am able to login RPD in Online mode. below is the error i am getting when i try to login to analytics.

below is the error screenshot. i am not able to connect RPD in online mode. when i install with default sample RPD and Webcatlog it was working fine . when i upload Custom RPD and Web catalog , i got the following error. 

No error when i upload RPD, it was successful.

[OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 2b1c] [43065] The connection with Cluster Controller ::ffff: <IPAddress>:63633 was lost.

OBIEE 10G/11G - SA System subject area [Gerardnico]

is the Source Qualifier query fetched any records? if not consult DBA for the issue on the SQL Execution in DB. 

are you looking for OBIEE support with office 365 or office 2016? you can follow the below link for Office 365 reporting in OBIEE. https://www.cdata.com/kb/tech/office365-jdbc-obiee.rst You can find the in oracle support the document is Smart View Support Matrix and Compatibility FAQ (Doc ID 1923582.1).

please follow the steps in the below link How to Fix OBIEE 11.1.1.7.1 EXCEL 2007+ Download Error | The Big Data - Business Intelligence by Sandeep …

first create alias tables in physical layer and follow the physical joins in Physical joins and create logical Fact and dimensions in BMM Layer.

based on you screenshot ,i hope the Java installation is not accessible for the user which you are using for patch apply.

OPatch uses the jar utility that comes with JDK for its jar, war, and ear operations. Opatch searches for JDK inside the specified Oracle home. If the Oracle home does not have JDK, you have to use the -jdk option in OPatch to provide an alternate location. OPatch displays an error if there is a jar/war/ear operation and…

please use the following Firefox versions.

In OBIEE 10g it works as you expected , but in 11g it is not there the label displays full hierarchy while drilling down. alternate way to make this is create individual reports and give action link one to another.

I think , 7.0 x means , it supports IIS 7.0 and IIS 7.5 not IIS 8. if possible uninstall IIS8 and install IIS 7.5 and proceed.

Thanks for explanation.

i think we won't get situation to join dimension and Fact using Opaque view. if you see the actual query by Amol Palkar it is having join between 2 dimensions and join condition is sub sting of VAR CHAR Data type. i accept with Christian.