Ok, in all your examples you posted the AGO function is used wrongly. The syntax is: AGO(<measure_expression>, <level>, <number of period>) You don't seem to have a <level> anywhere in what you posted so far. If you want AGO to work at the month level, you need to tell the system to do so.

Are you really talking about BI Publisher reports? Or is it analysis (the Answers analysis you put in dashboards) ? You don't really provide much info, so it's all about guessing ... Did you look at the generated query? Most databases have limits on the number of elements in a IN clause, even Oracle is limited to about…

Did you configure your admintool properly? As said it's something happening on the client, therefore settings tnsnames in linux paths doesn't really help as the admintool is a windows-only program. 3984491 wrote:... you cannot import data. Data? Which data? There is no data imported in the admin tool, only metadata…

Well ... even by SQL you can't really bypass a limit set by the presentation service. So the question is more if you have the proper aggregations set in the RPD so that the query would return you a smaller number of results. As alternatives add a prompt and request your users to select something to see a subset of the data…

There are bunch of settings in instanceconfig.xml defining how many rows/columns/cells etc. to display for a query result. It's a OBIPS setting. The doc and various MOS documents cover them, there isn't a magic setting and those who say to set everything to "millions" are those who wants to use OBIEE for datapumping. For…

Hi, What is the exact message you get? What version of OBIEE are you using?

I now feel very sorry for those students By the way: do you maybe have a link or a reference where the credentials and address of this demo instance is posted? I wasn't aware of it and it's good to know there can be OTBI demo instances around when needing to check a thing quickly. My fight with Office is more generic,…

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…