Gianni Ceresa

Actually the first option posted by @Robert Angel is probably what you need. Action link accept parameters only in the query part of a url (so it means after a ?, so your target must have be able to understand the parameter like if you call http://mstg/Store/?uscode=1400007 ). OBIEE refuse parameters as part of the URL…

in How to navigate to another report by clicking value? Comment by Gianni Ceresa Mar 31, 2017 11:23AM

Just in case give a try to OBIEE 11.1.1.9 with your version of Firefox (you can just use OBIEE Samples V506 for a quick test). As OBIEE 11.1.1.9 is older than Firefox 52 you can't 100% exclude the issue will not happen again But the decision to upgrade will definitely bring you the additional benefit of having a current…

in OBIEE Problem Comment by Gianni Ceresa Mar 31, 2017 7:36AM

Souvik Sarkar wrote:Any other workaround? As said: no. Because attributes vs. measures and the measures will always be repeated for every single attribute. That's how the pivot view work in OBIEE.

in Customizable columns in Pivot view Comment by Gianni Ceresa Mar 31, 2017 4:43AM

Will already give you few bits of the possible solution ... You get the global idea: you set a variable in the first prompt and use it in the LSQL populating the second. The issue is that query you are trying to write, there are 2 things it must do: - limit periods for the same financial year of the period selected in…

in OBIEE-Prompts Comment by Gianni Ceresa Mar 30, 2017 6:58PM

Eimis Pacheco wrote:Well, I understood that the tool Analytics does not allow me to do what I was asking for, but you answered my question.So, how can I convey that Analytics does not allow us to do what I wanted as I asked for, in this community tool? You do that by marking the replies as "correct" or "helpful" :…

in Is possible to set a variable in the query used in the dynamic repository variable init block data s Comment by Gianni Ceresa Mar 30, 2017 6:13PM

Good you got what you looked for. So like the other, would be cool if you can close the thread as that's what actually help others (as they generally are close because provided a useful information). For now it is This question is Not Answered.

in Is possible to set a variable in the query used in the dynamic repository variable init block data s Comment by Gianni Ceresa Mar 30, 2017 2:39PM

So, based on what the FAQ and OTN rules suggest, you can maybe close the thread? For now it's still This question is Not Answered.

in How to retrieve a value based on a date selected by the user in OBIEE Comment by Gianni Ceresa Mar 30, 2017 2:36PM

Gianni Ceresa wrote:But it's not something like "take the result of this query, select the value of this column in the first row (or unique row) and assign it to the session/request variable". that's why ... You can't.

in Is possible to set a variable in the query used in the dynamic repository variable init block data s Comment by Gianni Ceresa Mar 30, 2017 2:10PM

As said the answer is to model it in the RPD via a lookup table (or at least have the table with the exchange rate available). As apparently you can't touch the RPD (but then what's the point of having to do a job if you can't do it the way it's supposed to be done?), something that was also posted earlier in the thread is…

in How to retrieve a value based on a date selected by the user in OBIEE Comment by Gianni Ceresa Mar 30, 2017 1:46PM

You can, in a way, set it using a variable (so using a variable to set a variable), look at this: OBIEE - How and where can I set a Request variable (SET VARIABLE) ? [Gerardnico] But it's not something like "take the result of this query, select the value of this column in the first row (or unique row) and assign it to the…

in Is possible to set a variable in the query used in the dynamic repository variable init block data s Comment by Gianni Ceresa Mar 30, 2017 1:41PM

Yes, it's not a system one. You set it from a prompt, that's why I gave the "second name" also : in the prompt they call it a request variable. But it's just a session variable in the RPD: OBIEE - How to set a server variable with the session type via a dashboard prompt (with a request variable) ? [Gerardnic…

in Is possible to set a variable in the query used in the dynamic repository variable init block data s Comment by Gianni Ceresa Mar 30, 2017 1:12PM

You can get values from the front-end back in the RPD, but not using a repository variable. It will be a session variable (also called request variable sometime) and you allow everybody to set it's value. In that case the user can assign a value to this session variable and it's available in the RPD (in columns formulas,…

in Is possible to set a variable in the query used in the dynamic repository variable init block data s Comment by Gianni Ceresa Mar 30, 2017 12:37PM

From "Business Intelligence" you go to "Subspaces", there you go to "Business Intelligence Foundation" and then into "Business Intelligence Suite Enterprise Edition (OBIEE)". Or just click here: Do not underestimate the number of people joining this forum with a query and asking "how do I make this one work in OBIEE" ? So…

in can I set a presentation variable with the results of a direct database request ? Comment by Gianni Ceresa Mar 30, 2017 12:22PM

Good point the LSQL to get your values isn't the most obvious one ... I have some "dirty" ways crossing my mind for now but I prefer to find something a bit more clean before to post it ... Let's see if others are also inspired

in OBIEE-Prompts Comment by Gianni Ceresa Mar 30, 2017 11:36AM

Hi Eimis, Breath in, breat out (and do it few more times ). There isn't anything wrong in asking something you searched and you aren't sure about. But ... If you look again (it's not my document, Timo wrote it, you "met" him on one of your duplicated thread yesterday). Really try to keep in mind the 10 points listed there.…

in can I set a presentation variable with the results of a direct database request ? Comment by Gianni Ceresa Mar 30, 2017 11:20AM

dileraco wrote:What do you suggest us to solve this problem in the best way? Not at all ... Right now you don't know what the problem is and the suggest approach is a way to identify the problem so that you can look for the best solution. Also following the reply from Sherry George: do you see something in the logs? More…

in OBIEE Problem Comment by Gianni Ceresa Mar 30, 2017 10:59AM

So you are using the latest possible version of Firefox, and as Chrome stopped working with OBIEE 11.1.1.7 until a bundle patch fixed the problem during an upgrade it can definitely be the case here as well. Ideally find another browser and test with that one (IE11 also has issues with your version and I guess the fix was…

in OBIEE Problem Comment by Gianni Ceresa Mar 30, 2017 9:52AM

Souvik Sarkar wrote:Adding columns would increase the no. of columns in Total after field as well, how do I control that? I do not have direct control over the Total columns individually. If you create independent measures for everything your totals will also be the same: you will have to create them by hand as columns…

in Customizable columns in Pivot view Comment by Gianni Ceresa Mar 30, 2017 9:06AM

Hi, Your requirement is understandable, but what are you asking exactly? Which part couldn't you manage to do? What have you tested and tried so far?

in OBIEE-Prompts Comment by Gianni Ceresa Mar 30, 2017 8:11AM

Hi Dilek, Isn't your browser the problem? 11.1.1.7.140114 is quite a old one and has issues with new browsers (just because the browser has been released 3+ years after OBIEE and changed the way it manage CSS / JS etc.). So what browser are you using when having issues? Do you allow auto-update of the browser? Did someone…

in OBIEE Problem Comment by Gianni Ceresa Mar 30, 2017 7:52AM

Welcome to the Oracle Analytics and AI Community

Gianni Ceresa Mod

Comments