"a screenshot of a Presentation table and you now talk about Physical table? Different way of doing things as it's 2 very different things." My bad, its Presentation table and was a typo And reading a document related to 11.1.1.3 without reading about the functionality itself, understanding what it does, and be able to…

To save time, please let me know if you or anyone have tried this to populate Physical Table and Column descriptions?

"Well ... by using it I can get a CSV file with the place to put my own description and populate them all at once." I was following Doc ID 1289344.1 and it seems that its for languages but let me try and see if it also works for descriptions to the Presentation Tables and Columns

Thanks Gianni for your reply and I had already tried that one but I guess thats not really what its used for

I tried but it doesnt work and here is the filter: I get the following error: ORA-30483: window functions are not allowed here at OCI call OCIStmtExecute. (HY000)

Thank you and it works It looks like: Last thing I was looking for is to get the First 3 STRM's and also have to remove Nulls. I was trying out the LISTAGG but it doesnt work well with ROW_NUMBER already there... Please let me know should you have some solution?

The values are from the same column and this is how it looks in a table:

Here is what I had to do: Open your repository in the Administration Tool to access the query limits functionality for an application role. Select Manage, then select Identity. In the Identity Manager dialog, in the tree pane, select BI Repository. In the right pane, select the Application Roles tab, then double-click the…

Thanks a bunch and I got it working by following your instructions

Thank you and Yes I am familiar with the settings... Let me see if this helps

Thank you for the input and as far as providing details lets say a User wants to run the report every time by a different Group of Marketers. I can have the Agent schedule and deliver the contents to the User with a Pre-defined filter which is set for a specific Group of Marketers. But I want this process to be automated…

Thanks a bunch!

"There are packaged solutions which have a list somewhere in a database to provides mappings (can't remember if OBIA is one of those), but it's not something out of the box in OBIEE, it's a different piece of code doing the job." So when you run a report through Catalog Manager, where does it exactly fetches the data from?…

Thank you! So you are suggesting that the Catalog Metadata and RPD Metadata is stored as mentioned in the (Doc ID 2067527.1) So any Catalog data such as Analysis Names or Catalog Folders are not stored in a physical database?

I tried the CASE statement but its not working and can you elaborate as to how it would be used? I am using a Static Text box on top of the analysis?

Nice and let me try

Sorry I dont have access to it but we will further proceed with the hardware team on this issue... The weird thing is that it works fine if you re-create the report but the next day the same report would not export the CSV file and its basically a ghost file

Just to further clarify its a BI Analysis on its own and not part of any dashboard... And its not a publisher report

Its a BI Analysis and BTW, restart of the services didnt help

All dashboards/analyses affected the same way? No only that one report