Hello Kim, The OBI limit implemented is indeed configured to 100,000 queried rows from the database. This is measured by rows collected during query-and-seek as opposed to the number of rows displayed or collated for displayed results. The more complex the design of a report, the faster this query limitation is reached, it…

Hello new.bi! There is not enough information in your request to assist you, I strongly recommend adding detail about the objects being used in your pivot structure and perhaps a screenshot of the layout being implemented. By your comment alone, there is no technical information that can be used to try and evaluate why…

Hello Kellie, It's likely your users will have to obtain their own copy of the item if it's to be placed in a user's personal folder. In past experience, options to force content into personal folders was not available as the user's personal folders are locked out by strict access controls. If you have access to the OBI…

Hello Andy, The options for these kinds of table formats are unfortunately very limited. You can use a pivot table to emulate a horizontal-oriented table by populating the Y axis and a measure without anything on X-axis but this generally works with only very specific displays. I know of no option to make a standard table…

Hello Alex, Unfortunately I don't believe there are any side-tools other than text editors that can connect to the OBI layer in this manner, generally Oracle is very selective as to what applications they allow to touch the actual RPD/Data model. From my experience, Notepad++ and Textpad tend to be the most popular tools…

Hello June, I am unable to look at your SR, however I am curious as to the error code you are seeing on your report when attempting to run. Are you getting an HY000 error or another type of error code? If the error is HY000, this would usually mean that an object's expected content or data type might have been changed or…