Karthi, You can try creating an Action Link on the dashboard directly, which will act as BACK button. This has to be done on the re-directed dashboard.

If you want to run the report on the basis of Current Month only, then you can use the DATE Functions present in OBIEE Answers section:

Can you share the physical and BMM diagrams? I can see only AGG Table is used to populate the data in report.

Hello, Can you share the physical and BMM diagrams? Also, are you seeing any errors or warnings in the logs just after the Logical Query?

Also, Is your date a "DATE" or a "TIMESTAMP"? This will also have some impact when accessing the presentation variable.

Hello, Do you have the priviledges to see the queries? Can you please check the value generated/assigned in the Manage Session section for "PV-START"? Also, please share the screens of the FILETR condition and the location where you have defined the Presentation Variable.

Good Question, but what are you trying, where are you trying? Any screens or some more insight will add value to your question.

You can check the <domain_home>/servers/bi_server1:- bi_server1.log, bi_server1.out <domain_home>/servers/obips1:- saw_log

Please post a screenshot of both your Physical join showing fact and dim, condition showing your join condition and physical sql generated from OBIEE.

I guess, it should be something like the below: <EnabledSchemas>UidPwd,Impersonate,UidPwd-soap,Impersonate-soap,SSO</EnabledSchemas> <SchemaExtensions> <Schema logoffURL="<YOUR LOG OFF URL>" logonURL="<YOUR LOG ON URL>" name="SSO"/> </SchemaExtensions> Something like this should be your entry... Also, setDomainenv.cmd…

Did you updated the instanceconfig.xml with SSO related entries as well?

Hey Sebastian, Please try disabling the INTERNAL SSO. Try searching the command "disableBISingleSignOn" and apply it . This should work.

Just check the logs: Odbc driver returned an error (SQLDriverConnectW). State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused. (08004) State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000) State: HY000. Code: 43126. [nQSError:…

Please post some example about what information you have and what is the expected output using xls or OBIEE screens.

Can you explain what is the issue with some screenshots? What do you mean by "When page # 4 analysis invokes an analysis from page level # 2, the date range from page # 4 is overriding the date range intended for page # 2."? Can you please explain this scenario using some screens? That will be really helpful.

No, a single column storing YTD values for each month in different rows. Something like below

@Gianni Ceresa, Yes, The variable is properly populated. I tested it by taking the variable in a single column in the same report and it populated the values dynamically once I changed the Prompts. @Christian Berg, The Problem is: I have a trend report for a Year and I have to display the YTD values (which are…

Hi Joel, Somehow FILTER USING and CASE is not generating the correct physical SQL and hence, the values coming are not correct. I am trying EVALUATE as an alternate approach. My requirement is to populate values from a column dynamically depending on the values selected in the Prompt.

Thanks Gianni, Had thought about it as a sleaky way, but again wanted to take Expert Advise to see if anything like this exists as "default" in OBIEE. Will mark this as answered.

Hello Abed, You will have to drag and drop the columns from DIM B which are required to be defined as "measure" in the FACT A in BMM layer. Once done, define your new columns as measures by applying appropriate aggregation rule. The same Fact A and DIM B from BMM should be exposed in Presentation Layer. If you have already…