Gianni Ceresa

Too slow Christian Still discovering places for dinner?

in TopN based on results of another analysis - sub-analysis with filters based on prompts Comment by Gianni Ceresa Jul 21, 2016 2:46PM

Hi Robert, You can manage the case as the presentation variable has a value if "all records" is selected (can't remember exactly if it's "all values" or something else, just display its value and you get it). So by adding a piece of logic you can end up with something like : 1 = 1 (if all values selected) or your condition…

in TopN based on results of another analysis - sub-analysis with filters based on prompts Comment by Gianni Ceresa Jul 21, 2016 2:35PM

Have a look at the option Andrew posted, it's a good combination with a prompt to set the values faster .... And just open a new thread for your future coming questions

in OBIEE: How can I keep multiple filters "on/off" when creating an Analysis report ? Comment by Gianni Ceresa Jul 21, 2016 1:09PM

Ok, that's a lot more clear So, the answer is now: sorry, no, the tool doesn't provide that functionality ... You can of course ask Oracle to develop that kind of feature if you want. The options you can try are prompts and use the "is prompted" as Christian posted. If you add it as an inline prompt you will be asked for…

in OBIEE: How can I keep multiple filters "on/off" when creating an Analysis report ? Comment by Gianni Ceresa Jul 21, 2016 12:38PM

Hi, Take the last backup you did of your catalog and restore the folder by copying it back (also take the .atr file with the same name as the folder located just next to it). If you don't have backups .... why? I guess this is a good motivation to invest 2h of time to setup daily / weekly backups of your OBIEE environment.

in How to restore deleted Catalog Objects? Comment by Gianni Ceresa Jul 21, 2016 7:09AM

Hi, Perm77 wrote:...when creating Analysis from Subject Areas, I like to design one report to serve many purposes. ...one was able to check and uncheck multiple conditions and save in report. For the first one I would just say it can go badly if you end up with a single analysis with 40 columns and trying to make it all…

in OBIEE: How can I keep multiple filters "on/off" when creating an Analysis report ? Comment by Gianni Ceresa Jul 20, 2016 5:43PM

% is the modulo operation, if you look in the formula editor into the math functions area you find the "mod" function doing the same ... TIMESTAMPADD(SQL_TSI_DAY, MOD(DAYOFWEEK("Time"."T00 Calendar Date"), 7) * -1,"Time"."T00 Calendar Date") DAYOFWEEK return you the day number in the week (1= Sunday, 7 = Saturday). If it…

in Week Ending Date Calculation Comment by Gianni Ceresa Jul 19, 2016 4:04PM

Hi, Did you try to do it by yourself? Because the post you link give most of the things you will need ... Based on your example, assuming you want to calculate value of Column B based on value of Column A you are looking to get the date of the last Saturday before the date (or the date itself if it's a Saturday).

in Week Ending Date Calculation Comment by Gianni Ceresa Jul 19, 2016 3:58PM

Well, if you don't change the analysis itself, you don't change OBIEE version and the query change then there aren't 10 places where to look for... 525401 wrote:....I don't believe they changed anything major. ... Never supposed that, mainly if you aren't part of the dev team doing the job Many things can change the way a…

in OBIEE building join to all bridges when fact brought in Comment by Gianni Ceresa Jul 18, 2016 4:45PM

Just to add that the RPD is interesting but the front-end elements are also extremely helpful, many analysis and pieces of code you can just copy/paste. Sample App must be mandatory to have for any OBIEE developer ... And .... it's free!

in How to show all the dashboards in horizontally. Comment by Gianni Ceresa Jul 18, 2016 4:07PM

Can't you just post a picture or something showing what you are looking for ? Because I can't really imagine how a list of 20-30 dashboard can be horizontal in a menu ... (and I don't really remember how 10g looked like as it was so long time ago)

in How to show all the dashboards in horizontally. Comment by Gianni Ceresa Jul 18, 2016 11:20AM

It's not important what it is or why it is, but a column without aggregation rule is not supposed to be into a (logical) fact table. That's why it becomes a degenerated dimension. So you add a new logical table to your business model, you add the columns of your logical fact without aggregation (so using the same physical…

in Fact tables with this non-calculation index will show unexpected result Comment by Gianni Ceresa Jul 18, 2016 8:13AM

Hi, You model it as a degenerated dimensions and then you set the content level to tell OBIEE how to manage it with the 2nd fact not having it as a dimension (the standard way of configuring conformed and not conformed dimensions in a model). Your fact tables must contain only aggregated columns.

in Fact tables with this non-calculation index will show unexpected result Comment by Gianni Ceresa Jul 18, 2016 6:51AM

525401 wrote:... I've never had to do this in the past with previous versions of this rpd. Does it mean you did an update / upgrade and now it is generating the queries in a different way? What version are you using and what version was the "past" ?

in OBIEE building join to all bridges when fact brought in Comment by Gianni Ceresa Jul 17, 2016 6:16AM

Hi, The easier way, as you also want to change the domain, would probably be a proxy server in front of it. So a standard webserver (Apache, Nginx etc.) listening on port 80 (standard http:// ) for reports.comcast.com and forwarding the request to your OBIEE server.

in How to change OBIEE Default URL Comment by Gianni Ceresa Jul 17, 2016 6:13AM

Another options, maybe a bit simpler and also faster ... DB1.dbo.FileB.ID = DB1.dbo.FileA.ID AND ( DB1.dbo.FileB.Type = 'XXX' AND DB1.dbo.FileA.Status = 'Active' AND DB1.dbo.FileB.Start-Date >= DB1.dbo.FileA.Start-Date AND DB1.dbo.FileB.End-Date <= DB1.dbo.FileA.End-Date ) OR ( DB1.dbo.FileB.Type <> 'XXX' OR…

in Can a CASE statement be used in a complex join in the Physical layer? Comment by Gianni Ceresa Jul 15, 2016 4:44PM

You can try something like that (quickly done, so double check the logic ...): DB1.dbo.FileB.ID = DB1.dbo.FileA.ID AND CASE WHEN DB1.dbo.FileB.Type = 'XXX' and DB1.dbo.FileA.Status = 'Active' THEN DB1.dbo.FileB.Start-Date ELSE DB1.dbo.FileA.Start-Date END >= DB1.dbo.FileA.Start-Date AND CASE WHEN DB1.dbo.FileB.Type = 'XXX'…

in Can a CASE statement be used in a complex join in the Physical layer? Comment by Gianni Ceresa Jul 15, 2016 4:38PM

Well, your CASE WHEN doesn't really make sense from a SQL point of view ... In a SQL query you can't write that kind of CASE WHEN, the THEN condition (and the ELSE) can't contain the = condition but it must return a column and you put the = after the CASE WHEN ... END. You must rewrite your CASE WHEN in a different way,…

in Can a CASE statement be used in a complex join in the Physical layer? Comment by Gianni Ceresa Jul 15, 2016 4:32PM

Not a simple checkbox allow you to define that kind of condition in the prompt, but you can easily setup a display condition on the section(s) of your page showing your analysis only if 3 or more values are selected. 1) You create you prompt without any special setting 2) You create an analysis containing only the column…

in OBIEE Dshbrd Prompts - How can you required e.g. 3 values to be selected by User Comment by Gianni Ceresa Jul 15, 2016 3:14PM

Hi Jerry, Yes you can use a CASE in a physical join. But you have to go into the Expression Builder as you don't have a special button like in 10g to create a complex join vs. a normal join, so OBIEE automatically makes it complex if required and it will decide based on the condition you write into the field inside the…

in Can a CASE statement be used in a complex join in the Physical layer? Comment by Gianni Ceresa Jul 15, 2016 3:07PM

Welcome to the Oracle Analytics and AI Community

Gianni Ceresa Mod

Comments