Welcome to the Oracle Analytics Community

Home› Chris Dabel› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Chris Dabel Rank 2 - Community Beginner

Comments

  • Hi Neil, I do not believe there are plans to increase the Agent CSV export limit.I recommend logging a Service Request to allow us to hear the businessrequirement and advise you on how we can help meet the requirement. Thanks,Chris
    in Agent Limitations Comment by Chris Dabel February 2017
  • Great point, Neil! Thank you for these tips! -Chris
    in Any way to bypass the row Limitation Comment by Chris Dabel February 2017
  • Hi, To do this, edit the column prompt > expand Options, expand the dropdown, then select SQL results. Then, edit the SQL like this, then save your Prompt/Analysis: SELECT UPPER("Folder"."Column Name") FROM "Sales - CRM Pipeline" FETCH FIRST 65001 ROWS ONLY Thanks, Chris Dabel Oracle Fusion Support
    in Format prompt selections Comment by Chris Dabel February 2017
  • Hi Neil, This is due to the parameters set in the BI config files on the BI server. Generally, these parameters cannot be changed for cloud BI instances. There is one setting for normal export to CSV, and another for Agents. You can get more rows of data by using the BI Cloud Connector, where you can schedule data…
    in Agent Limitations Comment by Chris Dabel February 2017
  • Hi, The row limitation cannot be changed. Do you have to analyze all the rows? Or can you get them via another method, then view them in Excel? Could you please explain what you mean by "analyze more than 25,000 rows of data"? What kind of analysis do you need to do? The answer will help us be able to advise on alternate…
    in Any way to bypass the row Limitation Comment by Chris Dabel February 2017
  • Yes, for this, you could do this: 1) Use a pivot measure for each of the columns containing the age range employee counts. The column formulas will look like this: Column1 formula: FILTER("# of Employees" USING "employee age" BETWEEN 16 AND 20) Column2 formula: FILTER("# of Employees" USING "employee age" BETWEEN 21 AND…
    in Stats Comment by Chris Dabel February 2017
  • The only way to really understand what is going on with this is to look at the underlying, physical SQL that the report is using. I recommend logging a Service Request so we can help you get to the bottom of it. Chris Dabel Oracle Support
    in SQL IS NULL error Comment by Chris Dabel February 2017
  • Hello, Please review KM Doc ID 1415725.1. We have also seen this error get resolved with a bounce of the BI Domain. Please log a Service Request, and we can help. Chris Dabel Oracle Fusion Support
    in Using Subject Area for Report: "Unable to retrieve metadata from data model" Comment by Chris Dabel February 2017