Hi, You paid yourself a 4 CPU server but couldn't afford more than 8Gb of RAM? That's actually one of the most absurd server I ever saw ... Please tell me it's not a 4 CPU server but a single CPU with 4 cores, and even in that case you are quite optimist with 8 Gb of RAM (most of laptops nowadays have more than that, so…

Hi, I would say it's doable. But I wouldn't select the 6 months from the prompt as you can't force the user to select continuos months, so you better ask the user to select 1 months and then you do all your logic. For example the user select the last month, you then display 6 months going back from the selected one and the…

So there are 2 things you can do: 1) close the thread, for now it's still This question is Not Answered. 2) post how you fixed, what you did (at least some hints) to help others who can have the same issue. Keep in mind it's a community forum, so you would have been happy to get an answer from somebody else and so it's…

Hi, I guess it has been written 25 times as answer to this question but let's write it once again .... Out of the box sections are vertical, not horizontal. As an OBIEE analysis is HTML it's possible, with a mix of JS and CSS to transform a vertical list of elements and make it horizontal. So if you want it horizontal it's…

That's why it's not nice to double post: Unable to retrieve content. Additional information for Remote Region error Because somebody answered your other thread and so you now have to follow 2 of them ... Can you at least close this one so the discussion will stay in the other one where Bec_Wagner posted something...

Well .... That's no luck Out of the box you don't have anything related to the prompt to "Clear All" all your prompts on the page. So a way would be to use the "Clear my customization" button but it will actually reload directly the page. You only other options (if you really can't put them together into a single one ...…

2944729 wrote:We are unable to use ago function in our report And what does it means? You aren't able to write the formula? You aren't able to find your column? Are you getting an error?

You can of course request an enhancement to Oracle for that. If you had what you were looking for you can maybe close the thread? It will help others as well Right now it's still This question is Not Answered.

Hi, The simple answer is ... you can't .... (AFAIK) You dan't have any option for that, all you can show on (next to) the bubble is the value, but not the name in the legend. Also because often the bubble is way smaller than the name in the legend depending on your data (and imagine if you have like 20-30 bubbles on the…

Well, sqlplus has its own dedicated connection, OBIEE use connection pool shared by other things in your system, that's why the info in the logs can be not correct because of the way it's measured and it really depends on what else is happening on your system, how your "pipes" between OBIEE and the DB are setup and also if…

Hi, Honestly don't even try to compare a command line thing with OBIEE ... Can you just imagine how many steps OBIEE execute for a query more than sqlplus? I would suggest to make a proper analysis of what happen when you run your analysis: https://www.youtube.com/watch?v=0W34l2O9GMo And don't try to compare incomparable…

Hi, If you expect to find a "pleaso_go_fast_AGO" no luck it doesn't exist ... 3016375 wrote:It seems to be the main issue of bad performance. Actually it would be better if you clearly find out if it is or not the main issue, because having the feeling it is to find out after 2-3 days of tests of possible alternatives it…

As Christian already said you can use a) because if not in-line prompt ( b ) it will not disappear. And your actual column in the prompt section can only display the values of your column: so if you don't have a value "all values" it will never display all values because it's not a filter and it's just about showing or…

Yes for the AD string, for the other one it's not remove the Authenticated User app role but remove it as member of BIConsumer. As you see in this screenshot BIConsumer has 3 members : BIConsumers (a group coming from a LDAP), BIAuthor (an application role), authenticated-role (another application role). You simply edit…

Hi Robert, This happen because in the AD authentication provider you just point on a high level branch of your AD containing all users and don't have any extra conditions to prevent every user to login. What you see (app roles assigned to these new users) it's because of the "authenticated user" application role. This is a…

Hi, For purely Informatica questions an Oracle forum isn't probably the best place. Informatica is not an Oracle product, it's was just packaged into OBIA as the pack required an ETL, in current versions of OBIA Oracle moved to their own ETL: ODI. So there must forums about Informatica on their site I imagine ...

You can also just add a count on one of the keys and that is your measure. In your tables there must be something countable or that can be aggregated, if you don't have anything you can't really do analysis but just reporting on your data.

Well ... You must define a measure somewhere as the BMM must be a perfect star, so there must be a measure and dimensions linked to it.

Hi Robert, I couldn't try your scenario (lack of time), but I have projects where I used a partitioned FACT table and just that, nothing else is partitioned. In other projects I have some dimensions partitioned and only that and finally other projects with a some facts partitioned and some not, some dims partitioned and…

But fragmented by what? What is the fragmentation rule?