Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Custom Landing page in OBIEE 12.2.1.4

Received Response
461
Views
11
Comments
SonPat99
SonPat99 Rank 6 - Analytics Lead
edited Aug 13, 2024 5:31PM in Oracle Analytics Cloud and Server

Dear GURUS,

I am trying to create a custom landing page for all the users who are logging into OBIEE.

OBIEE Version is: 12.2.1.4

I am following the "OBIEE 12c : How To Use Session Variable PORTALPATH? (Doc ID 2215294.1)", but am not clear about Step 9 from this post.

It just mentions to do the below changes:

"

Select Data Source Type = Database

Select Use OBIEE Server

"

However, after completing this part, OK button is not enabled in RPD and the MOS document does not mention anything about changing or inputting anything in the Query Section.

pastedImage_0.png

Please suggest what I am missing.

Also, I tried the older method of using PORTALPATH variable in Initialization Block, but seems this is not working in OBIEE 12.2.1.4. Can anyone share some light on the method of using PORTALPATH in OBIEE 12.2.1.4.

In short, my issues/questions are as below:

1. What is the method to create a custom Landing Page for all users using PORTALPATH?

2. What has to be inputted in the QUERY Section in the above image?

3. If PORTALPATH is not working, is there any other approach to do this in OBIEE 12.2.1.4

Many Thanks in Advance.

«1

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    You can't click "OK" until a query is provided: (from the doc)

    If you select Database as the data source type, and select the Use OBI EE Server optionThe SQL statement you use to refresh the variable might be written for a specific database. However, it will still work with other data sources because the SQL statement is processed by the Oracle BI Server. The Oracle BI Server can also provide functions such as PI that might not be available in the data source, and the SQL statement will work with other data sources supported by the Oracle BI Server, for example, ADF, SQL Server, Oracle, and XML files. When you select the Use OBI EE Server option, there is no need for a connection pool, because the SQL statement is sent to the Oracle BI Server and not directly to the underlying database.

    Don't you already have other session variables which are defined?

    Often people just select a connection pool as write a query like "SELECT <your portalpath value> FROM dual", but if you already have other session variables you can also just add your PORTALPATH one there inside (to not have to execute multiple init blocks).

  • Joel
    Joel Rank 8 - Analytics Strategist

    +1 @Gianni Ceresa. Add a SQL statement and you'll be up and running.

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Thanks a lot Gianni...

    I have followed the steps and created a new IB and related variables as below:

    pastedImage_1.png

    pastedImage_0.png

    I tested and it is returning the values as expected.

    However, when I'm logging into OBIEE, it is not reflecting the new Home Page.

    I checked the value of PORTALPATH by creating a sample Analysis and the value returned is all good.

    Please suggest if I am missing something here.

    Do I need to restart the services?

    Note: I had reloaded the metadata from Administration Page as well.

  • Gianni Ceresa
    Gianni Ceresa Mod

    I don't see your whole value, but it definitely starts wrong (not with a / ).

    Read again your MOS document you linked in the thread, the example they gave there inside is: /shared/_portal/Test3

    I don't see the first " / " in your variable.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1 to Gianni. Your path is wrong to begin with.

    /shared/Marketing/_portal/MktgOverview

    ^--- this is a valid path

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Thanks Gianni, that was the culprit...

    My bad, I missed it entirely and YOU saved the day...

    I just want to understand one more thing:

    I came across this link ("https://www.clearpeaks.com/customization-in-obiee-12c/ "), where they are talking about changing the values in the "bieehome.html" for custom landing page.

    Is this a better way or using IB and session variables to achieve a custom landing page?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    SonPat99 wrote:Is this a better way or using IB and session variables to achieve a custom landing page?

    No. that's actually pretty much the worst suggestion I have ever seen on this subject.

  • Gianni Ceresa
    Gianni Ceresa Mod 
    SonPat99 wrote:Is this a better way or using IB and session variables to achieve a custom landing page?

    Honestly that page shows everything you MUST NOT do in OBIEE. The person writing that page has not a single idea of how OBIEE customization works as they randomly edit files. At the first patch applied on the system most of those "hacks" will disappear and you would need to restart everything again.

    There are various way to customize OBIEE, they are documented and supported. What that page does is the opposite.

    For your need imagine that you need to change the landing page and use a different one: the page you link require you to edit a file on the server and restart everything. What you implemented using the supported PORTALPATH just require you to open online the RPD, edit an init block and save and done. I don't know you but between editing a file on a prod server and having to restart vs editing an init block and save, I clearly take the init block way.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @Gianni Ceresa nicely put. I was too fed up to type it out.

    @SonPat99 that kind of blog post (content) is precisely the sort of thing which destroys the implementation of the product at clients. And hence the product's reputation.

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Thanks to both Christian Berg

    You guys explained the things very clearly.

    I too will go with what Gianni has suggested... PortalPath way.