You need to not double post! How to change the column value names in OBIEE It's against the ODC forum rules (maybe worth a refresh) and you got your answers in the other thread. So go back there, mark as required if you got the answer or just ask more details of you don't get what the replies means. The answer is there (it…

(missed a bit of my answer) If the agent send a page you will need to "solve" the 1 to many link between a page and objects, for that the scripts to parse web catalog you get from SampleApp 607 can help you getting this mapping. So you can link from agent name to agent analysis (via the agent ID) to UT (by the path) or…

I don't have a DB with a RCU available right now so it's an answer based on what I remember ... There isn't a direct link (column = column) between the agents tables and the UT table. You can only try to go through the path of executed object. The real reference of what an agent execute is in the agent XML, in the DB you…

Hi, you can do it with a CASE WHEN. It will work but it's not really the right way to "fix this". You are supposed to have the "friendly" value in the DB directly, maybe in a lookup table if you don't want to add a "friendly" column to the table itself. If you implement a CASE WHEN in OBIEE you better do it in the RPD at…

3580870 wrote:Anyone provide me the solution ... Provide all the details and it will be easier to try to get you in the right direction : More in general you can definitely start by investigating browser cache, mainly if the new logo is visible in all the other pages except these 2.

srikanth_p wrote:I already joined fact to month table ,fact to qtr table ,fact to year table using there respective keys . I just can't picture that in my mind: you have 3 tables for your time dimension? In general you have a single time dimension with many columns, one of the columns could be "year_start_date", so you…

As always the changes in query generation aren't officially listed, but 12c changed quite a bunch of things on how query are generated. That's why there is a flag to make 12c work as an old 11g, but don't get me wrong: I'm not saying you have to do that as you are going to lose all the new things, so what would be the…

Hi, I didn't read all the details (of the query etc.) but few hints for you ... You can maybe try to add sequence numbers in your time hierarchy to help OBIEE generate a simpler query. As your issue seems to be on "when" (where) the filter is applied it will maybe not change anything, but still worth a look. Never forget…

Hi, Are you expecting someone here to randomly give you figured on how long it will take to migrate your unknown 11.1.1.7 (without more details on the version) to an unknown 12c (without any detail on the version) ? Doesn't really work like that ... Nobody can give you any of these figures, just because they only depend on…

If you got what you were looking for, can you mark as required and close the thread? It will help others with similar questions finding the appropriate answer. For now it's still This question is Not Answered.

You are storing your image in the OBIEE catalog, which is probably the worse place for that. Files stored in the catalog can't be accessed as a normal image store on a webserver, you need to access them using the OBIEE way to retrieve an object from the catalog. All the details here:…

Picture? Which picture? Do you see tables in any other schema? Maybe you just don't have the permissions, with the user you connect to the DB, to see tables in that schema ...

All depends on how the report is sent and the amount of logs the SMTP has (like attachment names, subject etc.), a lot less friendly but just another option on top of others. The easiest is obviously what Joel said: it's generated by OBIEE, so of course it has the best links with OBIEE content.

On top of what Joel said, you can take the problem from the other side (outside OBIEE): your email are delivered via a mail server (SMTP), so look at the logs of your SMTP and you must find out exactly which email has been sent and to whom.

You better open a new thread explaining your case as the OP gave up on this (so didn't answer to any question etc.).

The issue you see is expected if you think at the agent from a security point of view: your agent is running as a specified user (which is referenced inside the agent itself), so OBIEE "login" as that user and execute the agent (run the analysis) and send the result by email to a list of random addresses you added. If you…

That's why the CSS was an example showing in which way it could be done (but I didn't spent 1h of tests on something I didn't need as 12.2.1.3 just works fine).

Did you read the blog post linked above on how to embed D3 in OBIEE using a narrative? There you see how to do it ... (https://www.rittmanmead.com/blog/content/images/2016/05/06663d3_narrative1.png ) @1, @2, @3 contains a single value each time, they are relative to a single row, so you need to use a piece of code which,…

It can also not exist and it's up to you to create it, but there must be for sure a JS library doing it ... (you then embed it the same way as D3) Look at this for example: https://plot.ly/javascript/3d-axes/

Hi, If you look into SampleApp 607 you find few scripts which extract data allowing you do that that kind of analysis... The idea is to search in the catalog (a XML search) the paths of the objects (your filter or your dashboard page), and there you get the list as OBIEE always use full absolute paths to link things. For…