Robert Angel wrote:if CurrencyType is a dimension in your underlying Essbase cube If only ... HFM has no cube, just a fake "multi-dimensional" model fully in relational DB. So everything is on the ADM driver and HFM hands to make it looks like a cube... @2900201 : my sample HFM VM crashed badly (right before I started…

When you edited instanceconfig.xml did you restart the required component? Because that's a mandatory step every time you touch the config file if you expect to see the result.

Hi, The instanceconfig setting is required (and then restart OBIPS) but you also need the normal OBIEE privileges to use HTML. Did you check if your application roles have that privilege? (In the OBIEE front-end admin page)

You are talking about creating an analysis but in the same time describe tables and database structure and talk about SQL. Do you have a pre-built RPD and so you can only build analysis on top of it? You have to create the RPD first and then the analysis? It's a bit unclear what you exactly expect ... As Robert said, OBIEE…

The query is for sure not a simple 1 line query but a bit more, so it takes some time to read it but still ... Actually I have a hint for you on how to find the issue ... For the analysis with the monthly figures vs the same month 1 year ago, try to divide the year ago number by the real number you got (so Jan 2018 Year…

You are missing the point: do not expect OBIEE 12c to generate queries in the same way as 11g does. The product will always try to get smarter and smarter and generate the best query. So if your model isn't perfect the query can change over the versions. That's why I said to take the physical query, read it, understand it,…

Your analysis generate a physical query, take that query, read it and understand what kind of logic it's applying. You will probably find the error in the model or where it is ...

The XML you get it from Catalog Manager. As it's a migrated object it can also have pieces in the XML which aren't in the GUI anymore (because of the change of versions). If you delete that prompt entry and create it again do you still have the issue?

As Joel said: check the logs. Things generally do not happen without being logged. Is that prompt new or a migrated content? Do you see "2019" in the XML of the prompt? By the way: you know that 12.2.1.0.0 isn't supported anymore for some time and it's also the most bugged of 12c being the very first release?

Variable, aliases and few other possible things. Bu you aren't really providing anything to give you a better answer ....

Did you check permissions? Remove and add the analysis again if you want to make sure you are really pointing to the right path ...

I'm with Robert : not OBIEE fault if your SMTP refuse emails. Double check the SMTP settings and ask the mailserver admin to have a check ...

Nothing special dedicated to OSSM. You have webservices in OBIEE allowing you to interact with the catalog and edit/delete/create things, so that would be your way to go if you really want to do it. More in general I wouldn't bet too much on OSSM: after it's first release it kind of stopped evolving, nothing really new as…

Mmhhh, sounds quite obvious: you get an Oracle database error because of the TNS not aware of the used SID. So fix your DB connection and the problem will be fixed (or give you a different one )

You got already some alternatives above on how to manage that need. Staying on the "default" way to manage things you would have to collect and analyse detailed web logs of the Adminserver: the EM interface you use execute actions when you add/remove somebody from a role, so you would probably extract these actions from…

Yeah, I was scared of that as it reference a level and so it's more strict than just a column in the formula itself...

Did you try using the CASE WHEN inside the AGO function for the value of the 2nd parameter? So something like AGO("... Receipts Qty", CASE WHEN VALUEOF(NQ_SESSION."LY_SHIFT") = 'GUNSHIFT' THEN "Core"."Date Retail Fiscal Calendar"."Gregorian Week" ELSE "Core"."Date Retail Fiscal Calendar"."Fiscal Week" END, 1) I don't have…

Christian Berg wrote:That's absolutely pointless since almost every single "issue" that even makes you LOOK into this tables is a false non-issue cause by - simply put: wrong usage and PEBKAC I agree, it's a badly (wrongly) managed security ...

chillychin wrote:If my users and security groups are stored in here, which table would it be? Don't get me wrong, I'm not saying it's nice and easy to get info out of the OPSS schema, but if you really want to you can. All the CT_* tables are kind of aggregated into the JPS_ATTRS. PS: as you double post (against the rules)…