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

RPD Custom Code

Received Response
11
Views
7
Comments
994426
994426 Rank 2 - Community Beginner
edited Aug 13, 2024 6:07PM in Oracle Analytics Cloud and Server

Hello,

In our Project, we get multiple requests to update the OBIEE RPD Presentation Layer. Specifically, the mouse-over definitions. The issue is that a minor change in the definition needs to be followed by thorough validation process from Dev - Test - Production RPD. Is there a way by which I can link an Excel document that captures the definitions for the attributes with the RPD? My idea is to update the Excel document, run some script (I dont even know if this is possible) which can update the RPD?

Also, a lot of reporting tools have some kind of access to metadata/system tables/SDK/methods that can be used to make custom modifications. I dont know if OBIEE provides any such functionalities. There are lot of tools available within the RPD such as creating RPD documentation. Does anyone one how that works? What language has been used to build that functionality? I want to be able to create custom codes but I dont have any clue how to get started on this.

Your feedback is very valuable!

Answers

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

    Why reinvent the wheel when there's standard standard functionality doing that automatically for you?

    Localizing Metadata Names in the Repository

    pastedImage_0.png

  • 994426
    994426 Rank 2 - Community Beginner

    Thanks for the response Christian. But, I think this method is used to convert/translate the catalog from one language to another.

    My use case is that I want to update the attribute description of my RPD by not manually doing it in RPD but rather in an external file such as Excel/CSV that can be used to update the RPD. This will save time because I can make quick updates to the Excel which can trigger changes to RPD. I am not looking to translate my catalog into another language.

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

    Who says you can't invent a language called "MyLanguage" and use it to read from a DB table which contains what you want?

    But if you insist I'm sure there's someone in here who's willing to help you destroy your RPD. Of course it's way more clever to actually rewrite metadata than dynamically read from a table. You're absolutely right. Hardcode that stuff. Have fun.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Stop thinking you know exactly what you need and look things in a more objective way: all you are asking for is what Christian posted.

    You want to be able to change descriptions? Well ... there is a why to do it which is quite simple to use.

    So why do you fix yourself on the idea you need something else?

    Sure there are ways to dynamically update the RPD (look for NQS functions for example, you will discover the guy who talked/wrote about it is somebody you already heard ....), but this require other things to work fine and I can already tell you that you have 90% chances to destroy your RPD or corrupt it. So no need to worry anymore about Dev - Test - Prod as you will not be able to touch your RPD anymore and so deploy a new RPD and restart the service etc.

    Look what has been posted, try it and you will find out it's a simple way to have a dynamic source for descriptions ...

  • 994426
    994426 Rank 2 - Community Beginner

    Thank you Gianni for your response.

    It really sucks that I don't have access to a development environment where I can try this, I was just asking this question hoping there would be hope for a solution which I can suggest to my development team. It seems there is hope (thanks to yo guys).

    I will search on internet if I can find blogs demonstrating this capability (I am excited I have something to work on).

    Thanks a lot for your help!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    994426 wrote: I was just asking this question hoping there would be hope for a solution which I can suggest to my development team.

    There is. What I wrote.

    994426 wrote:I will search on internet if I can find blogs demonstrating this capability (I am excited I have something to work on).

    There is:

    Multilanguage-Support in use - Variables over variables - Andreas Nobbmann - Blogs - triBLOG

    https://debaatobiee.wordpress.com/2009/10/15/obiee-localisation-externalize-metadata-strings/

  • 994426
    994426 Rank 2 - Community Beginner

    Thank you Christian for the blogs. This is indeed very helpful.