1435218 wrote:We tried "fragmentation" in the business model - didn't work. How it didn't work? Because dynamic LTS picking is quite a common thing. It isn't really fragmentation as it is intended, it's more a way to pick LTS1 or LTS2 based on a fake column or a variable or things like that. Your situation is a bit…

Of course a proper SSO as suggested above is the ideal situation. As you ask for authorization I assume you agree in using an existing tool (LDAP / AD) for authentication. You can use a database to authorize users (it's covered in the official doc or in blog posts like…

You did an upgrade and things change between 11g and 12c. There are chances your RPD had something which worked in 11g but already wasn't 100% clean, so now 12c is a bit more strict on things and tell you that there is an issue. Open your model, look inside, run a consistency check, fix all the errors or warnings and than…

Hi, You marked the thread as "assumed answered" but you didn't post the answer. The idea of a community forum is that you take and you give, so when you find your own solution you still post it back in the thread as it will maybe help other users with the same kind of question.

Extending what Christian and Joel said, in your "imagine example" you are forgetting that authentication and authorization are 2 different steps. Authentication can (need?) to be managed by the enterprise LDAP/AD, but if you want to keep control of authorization you can perfectly do it and do not need to use the LDAP/AD…

Anirban1 wrote:What I understood is if I have 2 user and set PersonalStorageLimitMB=10, then each user will get 10 mb file storage. That's what the config setting comment says. I can't affirm it's the case as I never needed it, so I trust the comment in the XSD about that setting. So yes, it seems to be a setting to limit…

As Christian said: the file says it's for every single "home" directory. But doesn't mean that your catalog will then be limited to <number of users> * <PersonalStorageLimitMB> because there is still the shared part of the catalog which isn't a "home" folder. But at least let you keep a control on the size of personal…

You have the export to Excel of the whole dashboard in the menu (assuming you have the privileges required). Look at the code it has behind and do the same. A lot changed in 12c compared to 11g in the front-end JS, don't expect a code of 11g to work the same in 12c.

Isn't this a double posting with How to hide Credentials when LWSSO is disable ? Same topic, same question = same answers (and double posting is against the rules of the community)

I would adapt the filter as "functionally" it has a mistake: "Time"."Month Short Name" >= (@{pv_MonthShortName-99}{201801}) AND "Time"."Month Short Name" <= (@{pv_MonthShortName}{201901}) => if no variable it will return 13 months and not 12 For better readability and chances somebody will understand what's going on in the…

I agree with you, but you know the kind of answers SRs are having lately ...

Did you check the official doc? The topic is covered there giving info on options etc. (as you don't say what version you talk about can't really post anything more useful)

First thing to keep in mind: don't mix versions. Use the Admintool of the same version as the server or your RPD will be saved with a wrong version and you go straight into issues. Did you create objects in your new schema? In your description you just added a schema (user), but you don't say you added things inside. The…

I hate what about to write but .... Technically it isn't a totally blocking issue, the 12.2.1.4 Admin tool seem to not be certified for the import of an 11.1.2.4 cube (is there really such a thing like a certification for the import wizard of the Admintool? Never saw one, and the bug linked isn't accessible). This doesn't…

Have a look at the certification matrix. Essbase 11.1.2.* is certified for OBIEE 12.2.1.4.

Implement a proper SSO, credentials will not need to be sent to OBIEE. If you take the shortcut of using nqUser and nqPassword in the URL you accept by default to have the information available in the URL and exposed in various logs etc. as it isn't protected in any possible way.

Honestly I wouldn't implement any workaround ! If you do, nobody will ever look at fixing the data quality issue. In the meantime tell your client that it's not your fault if they aren't able to manage a simple thing as a proper list of clients, and all you can do is to give them OBIEE analysis using only the client ID,…

I'm not going to digest everything tonight but, the first thing I believe to get is that you have some serious data quality issues and you try to picture that into this "fake" category you call "Other", right? So you try to create a not existing category in your data, which is already an issue as OBIEE never generate…

Let's start from the beginning: which exact version of OBIEE? It looks like a 12c, but even if maybe it has no impact it's always good to know what we are talking about. Second thing: why going directly into the advanced editor? Can't you achieve the expected result with a normal simple analysis? Doing an union maybe? So…

Hi, You want to have a look at . Your post is maybe extremely clear for you as you spent 1-2 days looking into that thing, but remember that nobody here has your system in front (except if one of your colleague is on here). The more effort you do to write your thread, the better the answers you get are...