It has the limits of the search in the catalog page, so no, permissions only allow you to search in your own user "my folder".

Let's call it "flexible" design Most windows can take almost any aspect ratio and size: good for many things but you then pay that "flexibility" if you do not remember that.

DollyG wrote:I am using a different approach, instead of all column values, I am using 'SQL Results'. Hi, As you are not using what the product provides as functionality you can't expect to have a feature allowing you to fix the issues you got when not using the product functionalities. As soon as you move into "SQL…

Let's go back to basics on "resizable windows" Or it means you have no LTS at all, which means you can't do anything with that column anyway ... And as Christian wrote already you can do the same going through the logical table source (open that one and you find all the column mappings for that LTS).

875299 wrote:... and another for counting sku code's from random fact table.since for the counts it is hitting a random table ,i get wrong counts. Honestly in almost 10 years using OBIEE I never saw it using a random table. It uses what you designed and modeled in the RPD, I don't imagine it being really random. And…

Hi, I would say the wrong tool for the job ... If you export the CSV it will be faster and probably not have the issue. CSV will export the result of the query instead of export the result of the view like Excel will do. And last option: why don't you connect to OBIEE directly by ODBC and run a logical query against OBIEE…

The extend a bit the concept : you can easily get a list of enabled agents on the old system, you can easily enable them by code => you can script that. Plan B: being a one shot thing you enable them using the provided dashboard by checking the ones you need by hand (up to you to evaluate if it's worth to script things on…

Hi, Sure you can, but it's up to you to select the ones to enable because of what an agent is and how it is managed in OBIEE. https://gianniceresa.com/2017/03/obiee-12c-agents-enable-them-by-code/ https://gianniceresa.com/2017/03/scripts-to-use-agents-in-obiee-12c-mass-enabling-and-execution-from-a-page/

Hi, Did you looked at the generated queries in the 3 cases and compared them? First the logical one and then the physical one? Did you manage correctly the default value in your analysis for when the prompt isn't set? Is your cache on or off?

Some extra reading with a direct link to time series functions: https://gianniceresa.com/2017/01/time-series-functions-why-how-what-where-obiee/ https://gianniceresa.com/2017/01/sequence-numbers-time-dimensions-new-obiee-12c/

Just for the part about having a not adapted network configuration on a laptop vs a server or a vm: in your log at some point you have something like t3://DESKTOP-1Q20P03:9500: [RJVM:000575]Destination 169.254.137.174, 9500 When you have a 169. address its when windows assign itself an ip address because no connection.…

Windows 10 is not a certified OS for OBIEE. It isn't expected to work on that OS. It's not you changing IP but your router doing it by itself (the joys of dhcp). Install Virtualbox and an Oracle Linux 7 vm: it's a supported os for obiee, will take about 10-15 minutes and another advantage is that you can take snapshots or…

What OS is that? I bet on a Windows 7, 8, 10 or something along that line ... If it's the case have a look at https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/ More in general you are using a name which is the name of your PC apparently, but in a "home network" IP addresses can change, so if your…

No problem, it's just probably the N°1 rule in here (because of MOS being a service you pay for), and they are quite strict about it. So better to avoid having mods looking at you

@puntano01 : it's nice to post back how you solved, but you better delete from your post the copy/paste you did of the solution itself. Just leave the link to the MOS document. It's forbidden to paste the content of a MOS document in the public forum (because it's what people paid for paying support). Also mark your own…

You have a "deal date" column in your fact table? That's what I meant by weird model. If you made the right joins in the model you don't need to keep a "deal date" column as this one is supposed to be equal to the day column of your date dimension. So get rid of it and you avoid the mistake. And you see once you take the…

Hi, I'm kind of curious to know what your model looks like as I hardly imagine how it is possible in a correct model to have a date like "10/10/2017" on the same row as "2017" AND "2018"! So I would say your "year ago" is fine and it's your model wrong (or weird) and your "Deal date" is not part of your time dimension, so…

That's why, even before to know which version, I wrote to delete the temp files of the browser. Gianni Ceresa wrote:Empty your browser cache and delete all the temp files. Without going into details of how IE works, if you do not uncheck the checkbox it just doesn't delete anything related to your favorites sites (and…

Empty your browser cache and delete all the temp files. And if you want more ... post more (versions of OBIEE, versions of IE, if IE was updated recently etc.)

user5922791 wrote:We have OBIEE 12.2.1.2 on Windows 10. You are using a not certified and supported OS (a client OS for a server tool), so you can't expect things to work as documented.