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)…

Internal LDAP is a proper LDAP for that, but things are also stored in the OPSS schema of the DB in 12c (mappings between application roles and groups or users etc.). All in all it's a good idea to stay out of these things and just keep using the UI for management

Honestly I will not say you are wrong in this memory, I just don't remember having see it and always saw people asking for it ending up with the javascript / css hack. Let's try the "historical reference for OBIEE": @Christian Berg, what's your memory about this? (and no, by "historical" I don't mean you are old .... or…

To recap the point: you want horizontal repetition of the table for each value of your "section" column. OBIEE doesn't (and never had) have this option. There are scripts around which does it (by using CSS / Javascript) as OBIEE is a web page and so that's the easiest way to visually achieve the result. Of course that's a…

What you see is right, because as you said the physical table is the same one And the last screenshot on the right you are inside the LTS, so you set your column to the formula you want and you maybe want to cancel all the others. I guess you want your "moderadora" LTS to source only the logical column "personas unicas…

Hi, First what version are you talking about? So you are saying you duplicate the LTS and you don't see it? Do you maybe have a screenshot? I would say you better set the mapping to logical columns in the LTS instead of the column. In that case you can't not see the LTS as you are using it and so you don't even have to…

Ah, that thing. I guess it always end up being related to OBIA things, so not sure if there would be any extra licensing or not. But still something to check if it works for real or not

The "size" isn't affected by the visibility option. The same properties your analysis (yes, it's an analysis and not a report except if they are all Publisher reports) has now will be there with the visibility conditions. The concept of "entire dashboard" is quite vague knowing it's a webpage and scrolls can exists both…