General OBIEE

Get Involved. Join the Conversation.

Posts

  • Stephanie Gott
    Convert Date FieldAnswered2
    Topic posted Yesterday by Stephanie GottSilver Medal: 2,000+ Points, tagged Analyses, OBI Answers, OBIEE Answers, OTBI 
    Title:
    Convert Date Field
    Summary:
    Convert from MM/DD/YYYY to YYYY-Qx
    Content:

    Hello,

    I have a date field I want to convert. I want to convert that from MM/DD/YYY to "YYYY-Qx". Any thoughts on how to do this? I've tried using the Calendar functions in the formula. They work, but don't get me the exact above format. I have to use two separate columns. One gets the quarter number so, in the example above, it would just say "1". The other column I'm able to get the year "2020". When I try do a Concat in the 3rd column, I get syntax error b/c I think it doesn't like to concatenate formulas apparently. Any help would be appreciated. 

    Thanks,

    Stephanie

  • Stephanie Gott
    Future Dated Activities1
    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 (at Client)
    Get privilege to issue logical SQL in OTBIAnswered21.0
    Topic posted September 11, 2019 by nathan morgan (at Client)Bronze Medal: 1,250+ 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 datesAnswered25.0
    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

  • 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

  • Rinku Gautam
    Customer hierarchy using BI Analysis (or OTBI)64.0
    Topic posted June 18, 2019 by Rinku GautamRed Ribbon: 250+ Points, tagged Analyses, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip 
    Title:
    Customer hierarchy using BI Analysis (or OTBI)
    Content:

    Hi All,

    I need to build a customer hierarchy report using BI Analysis (or OTBI).

    It should display Party Name, Party Usage and Primary Address.

    Can anyone help me in achieving above.

     

    Thanks,

    Rinku

  • Praveen Kumar
    How to get and SQL for our own OTBI AnalysisAnswered35.0
    Topic posted May 15, 2019 by Praveen KumarRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, BI Publisher Report Templates, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, OTBI, SQL 
    Title:
    How to get and SQL for our own OTBI Analysis
    Summary:
    SQL for OTBI Analysis
    Content:

    Hi All,

    How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub query and all.

    Where to get the SQL including sub query.Also help me with the navigation.

    Thanks in Advance.

    Regards,

    Praveen G.

  • Kunal Daya
    BI Publisher Excel Template13.0
    Topic posted March 27, 2019 by Kunal DayaRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Layout, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, Report Layouts, Reports, Sample Reports, Tip 
    Title:
    BI Publisher Excel Template
    Content:

    Hi All,

    We have a nested table and beacause of this we are receiving this row mark in front of the data

    Printing and Stationery" rowMark="2

    Does anyone know how to workaround this isse when nesting multiple groups in Excel?

    Thanks,

     

     

     

  • Linda Stelling
    'Publish for Subscription' in OTBI Agent4
    Topic posted February 27, 2019 by Linda StellingSilver Medal: 2,000+ Points, tagged OBI Answers, OBIEE Answers, OTBI, Report Delivery 
    Title:
    'Publish for Subscription' in OTBI Agent
    Content:

    Hi, can anyone point me to any information on how to best utilise this feature within OTBI agents. Ideally I am looking to establish a way to set an agent to notify recipients when an analysis has been run and data produced but not physically send it as an attachment (due to the inability to password protect the file).  I wondered if the Subscription functionality is the way to do this but I haven't really used it before so am a little unsure of what it's meant to do

    Apologies if this is documented somewhere obvious, I just can't seem to find anything. 

    Many thanks

    Linda

  • Senthilrajan Vaithianathan
    New features - BICCC 19A patch
    Topic posted February 13, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, Customizing Reports, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Reports, Scheduling or Agents, Upgrades 
    Title:
    New features - BICCC 19A patch
    Summary:
    Document for new features list in BICCC - 19A patch
    Content:

    New features has been added to BICCC Application as part of 19A patch, it is very good, but it will be helpful if we get some document from Oracle explaining the new features within BICCC for every major releases in Advance, Now I am looking for 19A patch new features list for BICCC. let me know if any of you have come across such documentation for BICCC.