KashSidd wrote:So when you run a report through Catalog Manager, where does it exactly fetches the data from? Do you happened to know? From the catalog itself, stored in the file system. The catalog is stored in the file system in a very similar way to what you see in your catalog itself: a folder in the catalog is a…

KashSidd wrote:Thank you!So any Catalog data such as Analysis Names or Catalog Folders are not stored in a physical database? There isn't a single piece of the catalog stored in the database in OBIEE. There are packaged solutions which have a list somewhere in a database to provides mappings (can't remember if OBIA is one…

KashSidd wrote:I know that the the above information can be pulled by running a report from Catalog Manager but instead I wanted to get to the tables directly so we can automate it. Why would one exclude the other? You really need to look at the command line options runcat.sh / runcat.bat has ! (runcat is Catalog Manager)…

Depends ... What would you have on the X axis? A picture is generally worth more than thousand of words, if you have a picture, a mock-up or anything else it would be easier.

Did you explore the structure of your analysis view? How is the code behind what you see on your screen, how the sections are structured? What kind of objects you could change to achieve what you want? More globally, did you search the forum here? The topic has already been covered in the past (11g is old enough).…

Take that script, look at what it does, look how it does it, replicate the same result adapting as required for your target version. The HTML structure of pages and analysis changed with versions, so you will need to adapt things. You can get there by a mix of JS and CSS. The logic and the idea is exactly the same.

Didn't you attend the webcast? It was targeted to you as you are an Oracle partner (Infosys definitely is!).

3770582 wrote:May i know will they release soon or would it take time ? Honestly that's really the impossible question to answer with Oracle There are products which are announced and 12 months later still nothing, others aren't announced and just are released. So I have no real answer for that, maybe somebody from Oracle…

Right now BI Apps is only on ODI 11g, ODI 12c isn't supported (the certification matrix gives you details about the very precise version numbers, but that's it). I heard there were work done on BI Apps 12c (so coming with ODI 12c and OBIEE 12c out of the box) but like always there aren't never dates communicated or…

99% chances the question was coming right after, so I provide a reply before he even has to ask

Once you went through data types and fixed that part I can already tell you the follow up question you will have: why is the result of the calculation of your 4th column not right? The good news is that the result is actually right. You will maybe want to look for "integer division" vs floating point division:…

Hi @3257179, Can you please stop mentioning random people in your threads? It isn't the most polite way to do things ... Never forget we aren't paid to be here and if/when we reply and try to support users and the community it's on our own free time (otherwise it's called consulting and come with an invoice someone has to…

The thing is that "they wanted it like that", so it means it's part of their process to not require UAT to be a full environment. The theory I guess is that UAT must be just like PROD to be the closer as possible and avoid any difference between what you see in UAT and what you get in PROD. So it means the client has a…

2604234 wrote:What are the advantages of having them do a full OBIA installation in UAT (so basically all 4 environments) as compared to just having OBIEE 12c? Wasting time and resources and money. OBIEE 12c isn't part of OBIA out of the box, it's already setup "on the side" doing an upgrade just taking the OBIEE content.…

user13510619 wrote:Yes it is analyses. You remember you posted that as your first reply 6 days ago? Because you said it was an analysis!!!! And now you are posting a Publisher screenshot. So, can you please clarify once (and stick to it) what tool are you talking about? OBIEE analysis or BI Publisher report? Because guess…

Sorry but you keep thinking at OBIEE in the wrong way. Why do you want "SQL logic" on the CSV? It isn't you writing SQL in OBIEE, the tool generate what it needs to get the data it needs. It isn't your problem how this is done. If you import your 2 sources in the RPD and make a join between them that's all you need. Don't…

OBIEE can federate sources together. That's why you have the business model and mapping layer where you must ignore the technical aspects of your sources and only think at the business meaning of things. There you can federate the 2 sources together into a single common model.

Hi, I don't have BICS around and it's ages since last time I touched it, but in a prompt there must be a checkbox inside the pivot table properties to say to hide columns/rows without data. So try clicking either on the "xyz" icon of the pivot table and look for that kind of option.

If you import your file as external table in your DB or as source directly in the RPD, the modelling work is done in the RPD which means that any analysis in OBIEE will have access to it. But you have to model it, it isn't a thing like "open a file on the fly and just get a row out", the file will act as a source which…

If you think at how OBIEE works you maybe better see why you are looking at the problem from a wrong point of view in a way ... You are mixing some business logic (the condition of an account being in a list of values) with technical aspects (the CSV file). The CSV file can be read by a database as external table, it can…