General OBIEE

Get Involved. Join the Conversation.

Posts

  • Wade Wilson
    BIP layout using space as a number grouping separatorAnswered15.0
    Topic posted February 11, 2015 by Wade WilsonSilver Crown: 22,500+ Points 
    Title:
    BIP layout using space as a number grouping separator
    Summary:
    We have a request from the business users at our Hungarian branch to show longer salaries as '123 456' in our Compensation Statement (from the Comp Workbench not Total Comp).
    Content:

    We have a request from the business users at our Hungarian branch to show longer salaries as '123 456' in our Compensation Statement (from the Comp Workbench not Total Comp). This is using a space as the grouping separator and no decimal points.

    I know that the grouping separator is supposed to use locale at run-time. So I've tried the format of <?format-number:BASE_SALARY_NEW;'999G999G999'?>. However, when we upload this in the Comp Plan, the locale appears to default to English and we end up seeing commas as the separators. I've also tried changing the locale AND default locale in BI Publisher on the template from the report (/shared/Human Capital Management/Compensation/Workforce Compensation/Compensation Workbench Print Statements). It seems that the grouping separator for Hungary's locale should be a space (http://www.localeplanet.com/java/hu-HU/). But the separator still appears as a comma for me.

    I've tried to force the format mask by using <?format-number:BASE_SALARY_NEW;'999 999 999'?> but this does not work and the extra spaces come after the numbers.

    My questions
    Is there a way to make the grouping separator be spaces?
    Is there a better/different way to set locale than what I'm doing?

    Thanks!

    Image:
  • Kristi Ashley
    Grouping data elementsAnswered25.0
    Topic posted February 10, 2015 by Kristi AshleyBronze Medal: 1,250+ Points, tagged OBIEE Answers 
    Title:
    Grouping data elements
    Summary:
    How do I bucket out a list of 13 sources into 4 source types using formulas or variables?
    Content:

    I am trying to find a way to use our source list of 13 different values and group them into 4 categories.  For example, I would like to group Job Boards, Social Networking, Email Campaign all into a category titled Direct Recruitment, and so on.  I have looked through the training materials posted and am unable to teach myself how to do this.  Does anyone else currently do this that could give me some direction?

     

    Note: I am currently using Business Objects at this time, not yet OBI.

  • Radhika Rao
    Fusion Reports and Analytic Pane : Restricting access on...Answered15.0
    Topic posted January 29, 2015 by Radhika RaoBlue Ribbon: 750+ Points, tagged Fusion, OTBI 
    Title:
    Fusion Reports and Analytic Pane : Restricting access on folders under Shared Folder
    Summary:
    Restricting access on folders under Shared Folder
    Content:

    What is the best practice to remove access to the many folders under Shared Folder (like Fusion Tap, Functional Setup etc) which should not be seen for certain roles. Also, would these changes be upgrade/patch resistant?

    Thanks!

  • Sonia Ahmed
    Need connection details for BI Office Plugin4
    Topic posted January 28, 2015 by Sonia AhmedGreen Ribbon: 100+ Points, tagged Customizing Reports, Fusion, Report Layouts, Setup 
    Title:
    Need connection details for BI Office Plugin
    Summary:
    Need connection details for BI Office Plugin
    Content:

    Installed BI Office Plugin 'Oracle BI for MS Office', downloadable from OBIEE homepage.
    Now am trying to create a new connection and need server details for SaaS instance.

    Where will I find the server details that can be used here?

  • Yaniv Weiss
    Problem on uploading XML and excel files as Local Data...Answered55.0
    Topic posted January 18, 2015 by Yaniv WeissBlue Ribbon: 750+ Points, tagged Customizing Reports 
    Title:
    Problem on uploading XML and excel files as Local Data Source to BIP
    Summary:
    Problem on uploading XML and excel files as Local Data Source to BIP
    Content:

    Hi all,

    Congratulation on the new merged Forum yes

    I need some urgent help.. 

    I have a Problem on uploading XML and excel files as Local Data Source to BIP, 
    on uploading excel and XML I get blank tables. 

    Thoughts somebody? I know there is BIP geniuses here (:

    Thanks

    Yanivsmiley

  • Amy Gregg
    RFT Template (eText Template)Answered15.0
    Topic posted January 12, 2015 by Amy GreggRed Ribbon: 250+ Points, tagged Customizing Reports, OTBI, Reports, Setup 
    Title:
    RFT Template (eText Template)
    Summary:
    Creating eText Template from a Data Model
    Content:

    Is there a way to automatically create a eText Template (RFT) from a data model?  We need to import specific data according to file specifications and am looking for a way to do that as this will be a monthly submission. 

    Attached template as an example for review.

    Thank you,

    Amy

    Document:
    SSN 341.rtf (125KB)
  • Gal Shani
    Duplicate rows in OBIEE reportsAnswered55.0
    Topic posted December 28, 2014 by Gal ShaniSilver Medal: 2,000+ Points, tagged Compensation, OBIEE Answers, OTBI, Reports 
    Title:
    Duplicate rows in OBIEE reports
    Content:

    Hi,

    Tried to eliminate the duplicate rows with the usual way (see attached screenshots), but it's seems this is not working on calculated field ('new salary', 'prior salary', etc'..).

    If someone can share his knowledge regarding this issue this will be very useful.

    Thanks,

    Gal.

    Image:
    Document:
  • Julian Challenger
    HOW TO... Include and Exclude columns in delivered reports5.0
    Topic posted December 12, 2014 by Julian ChallengerBlack Diamond: 60,000+ Points, tagged OBIEE Answers, OTBI 
    Title:
    HOW TO... Include and Exclude columns in delivered reports
    Content:

    Part of a series of short 'how to' videos to help with a variety of topics.  This short video shows you how to include and exclude columns in delivered reports which means that report writers can build less reports with excluded columns and report viewers can adjust the report to meet their specific needs at run time.  For example, a report containing many different person columns can be built and then a number can be excluded, users running the report can then include some of the excluded columns, depending on their individual requirement.

    Video can be found on Oracle Learning Library here.

  • Gal Shani
    SQL code which define dates as default in the report promptAnswered125.0
    Topic posted November 27, 2014 by Gal ShaniSilver Medal: 2,000+ Points, tagged Customizing Reports, Reports, Setup 
    Summary:
    SQL code which define dates as default in the report prompt
    Content:

    Hello,

    I know there is SQL code which define dates as default in the report prompt..
    For example- define the prompt on the "Assignment Creation Date" to run as of today-and will take the current date automatically.
    Can someone share his knowledge regarding the code? this will be very useful.

    Thank you,

    Gal.

     

  • Dudi Levi
    Working with Agents - OTBI - Help neededAnswered175.0
    Topic posted October 30, 2014 by Dudi LeviSilver Medal: 2,000+ Points 
    Title:
    Working with Agents - OTBI - Help needed
    Summary:
    I've setup an agent to deliver a report via E-mail... I tried everything but report is being delivered with no results\:
    Content:

    Hi,

    I've setup an agent to deliver a report via E-mail (as an attached excel file)... I tried everything but report is being delivered with no results\:

    BTW when I'm running the report from app it works just fine.

    Any suggestions?

    Regards,

    Dudi