Skip to Content

I have one webi report which is connected to universe..

Hi,

I have one scenario one webi report which is connected to universe which contains (US) related data from Oracle DB and in other DB i have UK related data.

My requirement is US user should see only US related which is Oracle DB and UK user should only see the UK related data which is in other DB.

How we can achieve this at report level.

Please help me out.

Thanks

Shiv

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2013 at 01:13 PM

    Hi Shiv,

    First of All, I would like to know which BO version you are using.

    In BO XI 4.x, we can use IDT with connections to more than one database.

    In case of XI 3.1, this seems to be possible through below steps.

    1. Create two seperate user groups for UK and US users.

    2. Create two seperate connections for UK and US.

    3. In universe Access Restrictions, map the user groups with connections.

    Once the user will login and refresh the report in Infoview, the specific connection should come into picture and he must see the data for his country.

    You could have a quick test and check if the above approach is working fine as I have not tested it practically

    Regards,

    Yuvraj

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      The big unknown with the XI3.1 approach is what type of database the UK database is and whether the structures match exactly or not. If it is SQL Server, for example, you have different syntax for even basic items like dates - e.g. sysdate v getdate() and the constructs surrounding them.

  • Posted on Aug 29, 2013 at 01:44 PM

    Hi ,

    You can achieve this feature using two different provider option in webi.

    1st data provider for US

    2nd one for UK

    n create two prompts country from both the data provider .So that user can select their choice.

    N pass the same prompt text in both prompts to display which country user has selected at the report level.

    Regards,

    Pranay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 30, 2013 at 10:14 AM

    Shiv,

    In BO 4.0 you can achieve this by creating security profile for universe in IDT.

    Ambreen

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.