Hi, Assuming you talk of "sorting" instead of "short selling" (shorting Meaning in the Cambridge English Dictionary ). Which exact version of OBIEE 12c ? Looks good in mine as long as the sorting column is placed before the "Dim 1/2/3" column.

Your customization is linked to a given page, if you look into the code of the customization you find the reference.

And if you don't have VA/DV licenses you are now up to pay tons of $$$ to Oracle as you used VA to upload the Excel ! @959d5b3b-a2b6-4462-ad3b-972dc9237eb3 : before to use VA to upload your Excel as posted by Asim make sure you are legally allowed to use it (= you have a license for it).

View selector simply switch between views, and a view just display the result of the query. The query is one and unique and so you can't change the filter of the query based on the selected view, for that you would need different analysis (as the filter is at that level). You can only try to "cheat" a bit but visually…

So the idea of having both as level based hierarchy as Christian said, using an opaque view if you can't do it with a view / materialized view / ETL in the DB, is probably easier as it will also answer your other point about filters: Report w/Parent Child Hierarchy not filtering But if you want to stay on parent-child you…

Depends what kind of filter you are setting .... You have the log telling you exactly what happen when you add a filter and have no record anymore. Hierarchies aren't filtered with a filter but mainly with selection steps. So look at your logs and you will see the reasons of the "no records" as the query will be quite…

933651 wrote:I think it is already strted because ./start.sh executed successfully. Maybe I have to do some other steps. That's why next to start.sh you have status.sh giving you the exact status of your environment. What kind of install you did? Did you load the SampleSales Lite BAR file during install? Because if not ...…

Is OBIEE really running? Can you login on the web page of OBIEE with these credentials? Weblogic Console and Enterprise Manager isn't OBIEE, they are on the weblogic Admin server and can perfectly works while OBIEE is down or your user can't login to OBIEE because you are missing the security (if you didn't import the…

Long story short: choose between spending hours and days trying to make it works and install virtualbox and have your OBIEE up and running 30 minutes later. Follow the link posted above by Pedro if you want to start with SampleApp which is definitely something every OBIEE user would need to have.

Christian gave you the answer (you are asking something which doesn't make sense as OBIEE and Informatica will never interact one with the other). If you actually mean if your OBIA 7.9.something using Informatica 9 can be deployed on OBIEE 12c then you just need to look at the certification matrix. And the answer is yes as…

As long as you executed the same exact query using the same exact account against the same exact database you must remember you also have the local settings playing a role in how a query is executed. If with all the above mentioned elements being the same your Toad gives you a different result than OBIEE (and you are 200%…

Well, I can't say what the licensing contract clearly state as those papers sounds like Chinese and it's more a topic for your legal department. From a practical point of view it's generally not a good practice to expose this kind solution to the external world directly. I would say it's not the main job of OBIEE to…

What would be the difference for you between installing OBIEE in a DMZ, in your normal internal corporate network or on a server without network? Nothing really change for OBIEE : as long as the server has a name / ip and it can reference itself OBIEE is happy. A DMZ is more about you and how you manage the various access…

@Avinash Pentyala : you better delete the copy/paste from the MOS document. Just leave the link and nothing else ...

I assume that piece of code is the custom code format of the column or something like that as you have the "@H" reference inside which is generally used to represent the URL being the value of the column. You can do what you look for, but you will need to move all that code inside the formula of the column, so you will be…

Moving from 11.1.1.5 to 12c isn't really supported (you would have to first move to 11.1.1.9 or 11.1.1.7 first in theory). And it looks like the issue is more related to your own customization. Identify exactly what is generating the issue, if it is your own custom code (JS etc.) then it's up to you to fix it and make it…

'FY' || CAST((CAST(SUBSTRING(CAST(2017 as CHAR) FROM 3 FOR 2) as INT)+1) AS CHAR) This thing also result FY18 but doesn't depends on a database knowing what "TO_NUMBER" and "TO_CHAR" means and will work on any source.

Hi, Why to use EVALUATE and making your analysis DB dependant when the default OBIEE functions could do the same job?

Well .... he asked for users, roles and privileges. Then post back for users and groups and nothing more. I'm just asking if that is like "hey, I got this piece done, it already cover part of my need and now I still would like to add X, Y, Z" or it is more like "the audit guys have no idea of what OBIEE is, so by giving…

Yes ... and ? So you don't have a question anymore? Then close the thread. Are you still looking for what you asked? Then is you answer questions it will be possible to move forward.