Hi, As far as I remember into the XML of the agent itself you have the info. It probably doesn't help you ... but not sure you find it somewhere else. So for sure in the XML of the agent itself.

+1 Thomas And just a detail: that's not really a measure (how do you plan to aggregate a column having only "Open" or "Closed" as value?) but an attribute. So if you want to make things in the right way it must not be in your logical fact table but in a logical table acting as dimension ...

If your BI Server is down no need to try to upload or download the RPD, the component you want to talk with is down ... As the message you got said you have to check the logs, there is no secret answer like "do that and done", depend on what the issue is.

You don't the account to connect to the server (SSH or remote desktop) that we got it. But do you have an admin account in OBIEE ? By default it's like the weblogic account for example. Because, as Christian said, don't expect a magical way with no user or password (be realist: it's an enterprise tool, not a notepad file !)

Did you try setting the "sort order column" in the logical column representing that level of your hierarchy? Because for a random sort like the one you want there aren't miracles, you have to provide a column which does the sorting ...

First of all: what version of OBIEE are you talking about? 10g, 11g (which one? .5, .6, .7, .9), 12c? Reading your question in a different way I wouldn't say "No" directly ... I guess you actually ask if there is a way without having connect to the server remotely, like via SSH if linux or Remote Desktop if Windows etc.…

That's what a sandbox is done for ... You can't really develop offline and after 2 months of changes deploy your RPD and hope it works .... As a developer you would be more productive with a sandbox where you can develop and test your changed as often as you need, and then you would ideally have a set of regression tests…

Hi, First you could have done a search on here as the question as been asked and answered few times already. The short answer is that you don't have any Gantt chart out of the box in OBIEE. The longer answer is that you have 2 options: 1) you can cheat a bit and generate a kind of Gantt by using a stacked bar chart, have a…

And how this is different than 24h ago? nqsError:37001Could not able to connect to BI server instance Just FYI: double posting give you less (or no) answers as you don't follow the rules of the forum and netiquette and it's generally a sign of lack of follow up as you will have to maintain multiple threads ...

double post: nqsError:37001Could not able to connect to BI server instance.

Hi, So found what you were looking for? (knowing there isn't an ootb checkbox for that) If yes you can maybe close the thread?

Hi, OBIEE 11g (11.1.1.7) can work with a 12c database without problems. If your system is a prod system and so look to have a certified configuration (based on the certification matrix) you will have to upgrade your weblogic to 10.3.6. If in your upgrade you end up with exactly the same database just on 12c instead of 11…

Hi, for 1) if you really want to be sure about your order create a second column with the same CASE WHEN but returning a value (number) you use for sorting. You then make this column as hidden and add it just before the real column with the 12am-8am etc. values. In that way sorting on that numeric hidden column your…

Hi, Vehicle_Name has nothing to do into the Agent_Vehicles logical fact table. A logical fact table is supposed to contains only aggregated columns, any attribute column is not supposed to be there but must be modeled as a degenerated dimension. In that way you can set content level correctly to manage this non conformed…

So a little extra task for you: close the thread ... For now it's still This question is Not Answered.

Well ... as Informatica isn't an Oracle product you maybe can get more chances asking on an Informatica forum ... Assuming your question is about Informatica installed as part of OBIA for future needs you have the forum.

If you go in the Administration page of OBIEE and Manage Sessions from there you see the logs. In case you see only the logical SQL you must increase a bit the log level to see the physical query as well, in your case MDX. And also in the nqquery.log file.

Of course would be good if you can give some details (all what @rmoff mention and everything else you can). What I guess is that your source is Essbase, so it's a MDX query, without filter it works fine and with the filter it doesn't ... Can you compare the MDX with and without filter? Does it makes sense? Did you consider…

Hi, You get a message because if you select 31 and all the months there are many months where the 31 doesn't exist (if you select 28 you don't get the warning anymore as all the months have the 28). So there isn't a "checkbox" way to set an agent to run at the end of every month ... Do you really want to run it the last…

As said on the other one you are posting in the OBIEE forum, I guess you have more chances in the Data Quality forum ...