Sitemap

Amicuk Programming Answers

Last argument in AGO function

-0001-11-30   Views:0

Advertisement

Hi Everyone... Hope everyone is good . So we have this requirement where user want to see selected quarter last month, then previous quarter last month and previous year last month based on Year and Quarter selection. for example. Prompts: Year - 201

Hi Everyone...
Hope everyone is good .
So we have this requirement where user want to see selected quarter last month, then previous quarter last month and previous year last month based on Year and Quarter selection. for example.
Prompts: Year - 2013; Quarter - Q2
Selected Month (1)
Last Qtr Last Month (2)
Diff of 1 - 2
Last Yr Last Month (3)
Diff of 1 - 3
Country
Jun-13
Mar-13
Qtr Diff
Dec-12
Yr Diff
USA
1000
500
500
700
300
UK
1500
900
600
1200
300
Now if user select Quarter as Q3 then report will show:
Selected Month (1) - Sep-13
Last Qtr Last Month (2) - Jun-13
Last Yr Last Month (3)- Dec-12
So the idea is to take always last month of selected last month, last qtr last month and last yr last month.
Now I am using AGO function to get the Last Yr Last Month (3) where I need to pass the last argument as a dynamic value.
AGO("measure","month","month Number")
But OBIEE say that the last argument should be a consistent integer. So is there any way where we can pass dynamic value of "Number of Period". For example
for Q1 : AGO("measure","month",3)
for Q2 : AGO("measure","month",6)
for Q3 : AGO("measure","month",9)
for Q4 : AGO("measure","month",12)
I can use CASE statement for this but will it not create performance issue, just curious?
Please help me if we can do this in this way or can you please suggest me any other way to do this.
Thanks,
Suhel Dayer

The replay answer
Advertisement
Any thoughts here.... Need help..
Appreciate your time and efforts.
Thanks....
Suhel

Go to See the other 3 answers

Hot
I have an HP Pavilion dv6-3120us Entertainment Notebook PC with Windows 7(64-bit). I recently purchased a new bluetooth headset and am unable to get it to work with my laptop. The Previous headset was a Plantronics Voyager Pro which worked great with [More]
How do I convert AIFF song files in iTunes to ACC files to fit iPod? My AIFF files are appartently bigger per song than ACC files. How do I convert an AIFF song or playlist in iTunes to ACC files so they take up less room. Right now I can only fit 50 [More]
I am using my crusty but trusty 5G iPod with my new rMPB, and things have been working as expected for the month or so that I've had the new laptop. But "recently," (past few days?), when I go to eject from iTunes (current - 11.1.5), I get the e [More]
This is probably a simple problem, the drawer on my DVD re-writer/player will not stay closed.  I had earlier been attempting to copy a DVD which had a problem and wouldnt copy(using sonic)  Now the drawer keeps opening with or without a disc. Is it [More]
hello there how you doing and am new to this sql server forum and i suddenly popped to ask questions related to sql server and my question goes like this in sql server i have table called testt and it have more thna10000000 records and i have written [More]
I have created a report using direct database request and created a filters using Presentation variable as prompt However All choices from Prompt is not capturing but for any value its working fine. Please let me know how can we do for All choices wi [More]
hello friends, i am supposed to extract revesion level, matnr, plant from sap to an excel sheet. matnr and plant we can get from marc or mara, but i could not find revision level on these tables. the technical name is REVLV i searched for function mo [More]
hi i want to know about sequential file in data transfer.wat is the concept behind this. thanks in advanceI assume you are clear about the concepts of Application Server and the Presentation server. some times the data that has to be transfered in SA [More]
Hi all, I'm using ADF faces + toplink. I have developed a form that first inserts mandatory fields of a record via persistEntity function and later in same page after inserting mandatory fields of record, I want to update empty fields of record that [More]
I just installed the Express Admin tools and when I open Oracle Express Administrator, I get a "run-time error 380 invalid property value" and then it kicks me right out of the tool. Any ideas how to fix this? Should I re-install? Thanks, CarlaT [More]