It seems like the account is locked or something. I had that once some days ago already. Hopefully they will unlock it soon.

3984491 wrote:I thought it must be well known error. Actually the error looks like this It's more that often a single OBIEE error has a long list of possible database errors behind: like 17001, it seems to be a single error in OBIEE to say there was an error with the database, but the real error is given in the message as…

It's more to make sure Christian has the same error as you (as I still don't have the add-in, fighting some internal battles with my Office setup). In the picture he posted the connection was on HTTPS but port 80, which make the test not valid imho. If he has the same error as you, it probably means that there isn't any…

Don't scan anything Christian and just trust me: port = 443 (I'm using all the webservices of that instance on port 443 for some auditing and it's a standard cloud-like setup with a proxy in front of OBIEE to expose the standard HTTPS port)

If it's just few columns, it's often easier to add them by hand (right click > new column, enter the name and type, done). When you import using the wizard it use the local info, not the server, therefore your DB connection settings needs to work locally too. And just error numbers doesn't mean much: I doubt people knows…

Could you try with port 443? (adding it explicitly if you didn't enter it in your previous test) HTTPS on port 80 would be too weird even for Oracle!

@Joel Acha & @Christian Berg : in the browser it works, but what Mark is trying is to connect to this instance from the BI Publisher add-in in Microsoft Word. @Mark.Thompson : sadly I don't have the add-in available right now to give it a try and confirm I have the same issue ...

Hi, You are talking about custom developed code you deployed on your own OBIEE server. Nobody else than you has that code (and all your colleagues at GE as those are internal links). All I can say is that you deployed jQuery in analyticsRes which is useless as jQuery is already into OBIEE 12c and it's also loaded by…

Hi, You maybe want to google (and search MOS) for documents about that as otherwise you will end up with some random figures. The RPD will be counted in Mb (1-10-100) on disk, that's it. It isn't a database thing at all. The size of the RPD depends on you and what and how you model things inside. As it's metadata it's size…

For OBIEE 12c look at https://support.oracle.com/epmos/faces/DocContentDisplay?id=2114441.1 I guess you don't want it as source for OBIA, so that tool doesn't really matter. PS: remember and to close your own threads as that's your contribution to the community forum

3808468 wrote:I want to see that complete dynamic filer values in the excell That's not an export ... An export is like printing: you capture what you have on your screen and transpose it on a piece of paper by printing it, or export that current status in an Excel file, which is totally disconnected from OBIEE. What you…

Are you sure the variable is set? How did you test that @testvar is properly set?

What Massimo said will do it (as your "Total" is a column/formula and not the total automatically calculated by OBIEE you are almost there). As extension to his comment: if you have other dimensions/attributes and run into the "wrong data" (which is actually right data but not what you expected) you could bypass the issues…

Sorry but ... what are you talking about? The more efforts you invest into writing a detailed thread with as much information as possible, the more chances to get a proper answer you have ... (this also apply to your other thread on hadoop which become SAP Hana). Maybe also worth looking at as you don't have a single one…

"BBB"."Pattern" = "BBB"."Pattern" : what do you expect to get from this one? You are setting a condition like 1=1 ForSly wrote:what did you mean by this (string are written with ', not " .) 'whatever' => this is a text value "whatever" => this is a reference to an object named whatever For example: CASE WHEN…

Use the "selectors" on screen to reference columns. In OBIEE a column is always referenced as <presentation table>.<presentation column>, therefore your current syntax can't match anything. And also: string are written with ', not " . "Family Name" would be a column named Family Name.

The concept of weekends and public holidays is extremely subjective: for some weekend means Satuday-Sunday, for others Friday-Saturday. Public holiday is even worse as in a single country they could be different by region etc. Therefore this meaning is 100% a metadata which needs to be part of your dimensions. To be more…

It sounds like you tried to "fix" it before to find out where time was spent. If it takes 10 minutes you must be able to map out exactly which step took how long, as that is what will drive your "fix" approach. Push logs and do a time profile for that analysis. This will help you in finding where time is spent, and for…

You mean the Oracle SQL "partition by" clause used with analytical functions? Nope, the BI Server speaks LSQL, not Oracle SQL. You aren't writing a physical query which will be evaluated by the database but a piece of query which is sent to the BI server. If you want to send code to the database you need to use evaluate…

Sure ... kind of .... Save it somewhere, read-only access from devs, name it "whatever-name-you-want-template". Devs are going to copy/paste it to have the template instead of an empty new dashboard. That's what you can do.