In an analysis (not report, analysis) a filter if it isn't protected will be replaced by the values selected in a dashboard prompt if any. Therefore your analysis is probably running with a very different filter. Add the "filter" view in the analysis and you will have a hint, look at the generated query and you will be…

3923818 wrote:Hi,Thank you for the reply. Please help me to understand better with your question as the default value for this setting is NO. https://docs.oracle.com/middleware/11119/biee/BIESG/configfileref.htm#i1076541 Oracle seem to disagree with you ... A.6.2 PROJECT_INACCESSIBLE_COLUMN_AS_NULL Controls how…

What exact version of the tool are you talking about? An official doc says this: The default value is YES

3923818 wrote:I have changed the setting 'PROJECT_INACCESSIBLE_COLUMN_AS_NULL as YES' Why was it at "NO" before? Because 'Yes' is the default value... And would be good if you could post some more info, right now you don't give much. (More efforts put into writing a thread result in better answers)

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…