General OBIEE

Get Involved. Join the Conversation.

Posts

  • Stephanie Gott
    Future Dated Activities
    Topic posted September 17, 2019 by Stephanie GottSilver Medal: 2,000+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI 
    Title:
    Future Dated Activities
    Summary:
    Show me only the Opportunities that don't have a future dated activity added
    Content:

    Hello,

    I'm struggling to think through how to do this. Here is the business problem we are trying to solve: We want our sales people to always have at least one activity tied to the opportunity that has a date in the future. They can have many activities on an opportunity with dates in the past, dates in the future, or no date at all. I would like to show my sales leaders the opportunities that don't have a future activity at all or is blank. Here is what I've tried so far: 

    CASE WHEN "Activity"."Due Date"> Current_Date then COUNT(DISTINCT "Sales - CRM Pipeline"."Pipeline Facts"."# of Opportunities") else 0 end

    When I do this and the sales leaders filter on just the '0', they may be looking at opportunities that actually do have future dated activities on them (because remember, you can have many activities to one opportunity). 

    I've also tried creating an analysis that shows me all of the opportunities that do have a future dated activity and then using that as a filter on another analysis where the opportunity ID does not equal one on that list. That doesn't seem to be working either because the seller may have opportunities with past or current date that won't show on that list because they also have a future date. Does that make sense? 

    Basically, if you can't tell, I might just need help thinking through the best solution to this. I've spent hours on this and I fear the answer is very simple and right in front of my face but I can't seem to grasp it. Any help would be greatly appreciated. 

    Thank you, 

    Stephanie

  • nathan morgan
    Get privilege to issue logical SQL in OTBIAnswered21.0
    Topic posted September 11, 2019 by nathan morganGreen Ribbon: 100+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, Report Output, Reports, Setup, Setup/Administration 
    Title:
    Get privilege to issue logical SQL in OTBI
    Summary:
    As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log for diagnostics like physical sql
    Content:

    Hi,

    Does anyone know if in Oracle Cloud Application, we are oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0), does a role exist that has been granted privilege "Admin:General"/"Issue SQL Directly" by person with bi administration privileges who went to the Administration menu then the page "Manage Privileges" to assign that privilege to a role. Our development team who are writing extensions using oracle transaction business intelligence (OTBI) real time subject areas, to be productive, need the ability to issue logical sql, view results with the log level set > 0, then view the log file with rich diagnostics like timings and row counts and the actual physical sql. To achieve this on onpremise projects the administrator had granted the above role to developers. We assume that the bi administrator role is not allowed to be granted in cloud therefore we can not set this up ourselves. In Navigator/Tools/Security Console I have assigned the following roles "BI Consumer Role", "BI Platform Author Role", "BI Publisher Data Model" and even "BI Platform Repository Manager" and "Business Intelligence Content Administrator" but none of these give me the "Administration" menu in /analytis/ nor the ability just to go to "issue sql" saw.dll?issuerawsql or even "Manage Sessions" saw.dll?sessions. Thanks, Nathan  

    Version:
    oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0)
    Image:
    Code Snippet:
  • Stephanie Gott
    Filter on blank and future datesAnswered2
    Topic posted September 10, 2019 by Stephanie GottSilver Medal: 2,000+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI, SQL 
    Title:
    Filter on blank and future dates
    Summary:
    Create a filter using SQL expression to show just the null and future dated values
    Content:

    Hello, 

    I have a need to see only the null values and future dates. I'm strugglin to get the syntax for my SQL expression in the filter. I'm using "Is greater than OR null. See screenshots. Any suggestions? If SQL expression is not the right way to go, I'm open to other options. 

    Thanks,

    Stephanie

  • Abdul Karim OMAR
    BI publisher custom role7
    Topic posted August 26, 2019 by Abdul Karim OMARBronze Medal: 1,250+ Points 
    Title:
    BI publisher custom role
    Summary:
    BI publisher custom role
    Content:

    Can we create a custom role so the user can only have access to new data model for creating SQL queries and not able to edit existing data models, reports and templates?

    This should only to query data from back end.

    Thanks

    Karim

  • Pradeep Akula
    Not able to View Job history for OBIEE Agents in Fusion HCM32.0
    Topic posted August 19, 2019 by Pradeep Akula, tagged Core HR 
    Title:
    Not able to View Job history for OBIEE Agents in Fusion HCM
    Summary:
    Not able to View Job history for OBIEE Agents in Fusion HCM
    Content:

    Hi,

    As of now in OTBI we are not able to view the job History for the Agent? this feature is very use full to everyone, is there any possibility to add this feature?

     

    Thanks

    Pradeep A

    Version:
    Oracle Cloud Application 19C (11.13.19.07.0)
  • Stephanie Gott
    Future Dated ActivitiesAnswered35.0
    Topic posted July 29, 2019 by Stephanie GottSilver Medal: 2,000+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI 
    Title:
    Future Dated Activities
    Summary:
    Show Opportunities with Future Dated Activities tied to them
    Content:

    I posted this to the Reporting and Analytics for Engagement Cloud forum but I don't have great luck there so I'm putting it out here too.

    Hello,

    Our Sales Leaders require our Seller's to have at least one future dated activity on each opportunity.

    Business problem we are trying to solve:

    “Show me all of the opportunities that don’t have any future dated activities tied to them”.

     

    I created a report and am using this Case When Statement to show all of the future dated activities on an opportunity.

    CASE WHEN "Activity"."Due Date"> Current_Date then "Sales - CRM Pipeline"."Pipeline Facts"."# of Opportunities" else 0 end

     

    The problem I'm running into is this: If I filter on just the zeroes, that would make it seem like Michael Johnson doesn’t have any future dated activities at all (see attached example). But he does. Any ideas on how I can show only the opportunities that only have zeroes and don’t have any 1’s?

    If anybody has a better way to get at this information, I'm open to alternatives. If anybody has ideas about how to fix my current solution, I am open to those as well.

     

    Thanks,

    Stephanie

  • Farooq Haider Syed, PMP
    NO Permission in BI Publisher --xmlpserverAnswered5
    Topic posted July 28, 2019 by Farooq Haider Syed, PMPBlack Diamond: 60,000+ Points, tagged BI Publisher, OTBI 
    Title:
    NO Permission in BI Publisher --xmlpserver
    Summary:
    NO Permission in BI Publisher --xmlpserver
    Content:

    Hi,

    The admin user have the folder permission in OTBI / analytics but permissions are greyed out in xmlpserver. Same right but different access.

    How can we get the permission in xmlpserver.

    Thanks

    Farooq

    Image:
  • Samrat Chattapadhyay
    Audit History to access changes made in BIP Data Model2
    Topic posted July 25, 2019 by Samrat Chattapadhyay, tagged BI Publisher, BI Publisher Data Models, Customizing Layout, Customizing Reports, Data Models, OBIEE Answers, OTBI, Reports 
    Title:
    Audit History to access changes made in BIP Data Model
    Summary:
    Require table or methods to find out changes done in BIP Data Model
    Content:

    Hi,

    We have encountered an issue recently where the data model query were updated by someone and the reports refering to the same data model started failing because of the changes.

    Is there any way we can have and audit on the BIP Templates or Data models to find out what was the changes done and who incorporated the changes.

    Any help in this is much appreciated.

    Regards,

    Samrat

  • Vishal Gala
    Need a SQL query to list all the scheduled OTBI Analsis and...15.0
    Topic posted July 22, 2019 by Vishal GalaBlue Ribbon: 750+ Points, tagged OTBI 
    Title:
    Need a SQL query to list all the scheduled OTBI Analsis and dashboards
    Summary:
    We need to review and track all the OTBI reports that are scheduled via agents
    Content:

    Having the ability to query this out helps us understand who all have scheduled the reports other wise there is no easy way for the administrator to know..

  • Christine Pritchard
    Oracle report development methodology44.0
    Topic posted July 9, 2019 by Christine PritchardGreen Ribbon: 100+ Points, tagged BI Publisher, OTBI, Public Sector, Reports, Tip 
    Title:
    Oracle report development methodology
    Summary:
    Looking to see if there is a suggested report development methodology for use across Oracle reporting tools
    Content:

    Using HCM & ERP and wondering if there is a recommended report development approach that includes report business/functional & technical specification templates, specifically aimed at the different Oracle reporting tools available

    Many Thanks

    Christine

    Version:
    19B