Hi @Christian Berg Our organization is a cancer hospital, we have developed our inhouse application (6000+ front end objects) in oracle 11g forms and reports and database oracle 12c, application is called as "HMIS" (Hospital Management Information System). There are almost 200+ management end users at one location and…

If we enable SSO then end user has to re-authenticate the BI login page for dashboard when open from oracle application by using webutil.client_host which is not acceptable to our end users. Currently our end user is able to open his/her dashboard from our inhouse developed application menu and there is no…

thanks, it is working fine, I am uploading screen short for others where to set the scope

Hi @Gianni Ceresa I think you were asking about this feature, Am I right? If I am right, actually my requirement was slightly different that's why I didn't used this feature and achieved with filter value.

Fig.1, break into two Fig.2, analysis is working fine Fig.3, Error when open that analysis on dashboard

Hi @Gianni Ceresa I will I shall be greatful if you please comment on presentation variable (Images attached in this thread), what I am missing? I want to use between clause (from month and to month) Month format is 'YYYY / MM' values (2019 / 02)

Hi @Gianni Ceresa I have already read the shared document and read today (but not thouroughly today), If I am not wrong there is nothing about my problem. However I have resolved my problem with following, needs your expert opinion either it is good approach or not. Now data does not show until selection of some value from…

Hi @Robert Angel I never used Presentation variable before, i have tried, please guide where I am wrong Steps how I tried From Month To Month First Tried this way, it generated error then searched at google and selected presentation Presentation variable Error Occured -- please guide which step I missed

thanks for the detailed information

We are using OBIEE 12.2.1.3.0 version.

We are using OBIEE 12, Surprisingly, I tried style "FusionFX" and it is working fine from few days but I was not sure either it is a permanent solution or just the solution for this dashboard graph only.

There was not a solution at all, it was a very basic mistake at model and data level which identified with continuous efforts, original field type was character with data 0010100 but during modeling mistakenly it was converted to number, starting '00' was truncating that's why CASE Statement was returning 0 amount instead…

Hi @Christian Berg Would you please explain your solution in little more detail, definitely your proposed solution will the best as you are one of the most senior at this forum. and as a junior we need guidance of our seniors.

Hi @Jerry Casey Thanks, Hopefully this is what I required, I shall update once implemented/tested

Hi @Thomas Doods As I understand your comments, you are talking about following (Fig. 1). If not, please explain your reply in little more detail for my better understanding. Fig.1, Time Dimension

Hi @Thomas Dodds I have fixed this problem, thanks for the comments

nice advise

Hi @Christian Berg Yes I got training few years back but started working now. I don't know why you commented last line but I assure you that everything will be fine. Soon I shall help to others on same topic as you people are helping me now a days

Yes, you are right, is this possible?

I have not checked the logs (infact I don't know how to check the query in BI Administration, query during analysis (Advance tab) was very simple which could not help me), I am creating new model as Lab Revenue