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…

Charles M wrote:Hi -You may want to consider using data lineage. What do you call "data lineage" ? Isn't that just an OBIA thing? Because the thing getting the close to data lineage in OBIEE itself is a bunch of scripts provided in OBIEE Sample App, or there is also a super expensive tool which does the same (but it's…

Look at what Joel posted: if you can do it in catalog manager then you just need to call catalog managed by command line and generate the same report like that. Schedule that command and done.

It was documented somewhere (and I guess it still is). Of course it doesn't cover "download a file to a specific directory and give the file a specific name" as the target directory can't be set and the filename is the same as the file in the catalog ...

Hi, The "specific folder" you have no way to set it, that would be too much. For the other part of the question depends a lot on what the "file" is and where it comes from

Hi, Based on your thread master-detail, as suggested by ArijitC, would be the natural answer except for a detail: you want the detail to be visible only after clicking on a day. Master-detail is more that the detailed analysis is always there and master-detail will filter based on the click. An alternative way based on…