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

How to pass argument in main function ?

Category:DefaultRelease time:-0001-11-30Views:130

How to pass arguments in main function of one class from another class ? I don't want to pass argument from command prompt. I want to try something like this - class Test{ public static void main(String args[]){ for(int i=0;i<args.length;i++)      Sy[More]

How to pass OAF filed data as a argument to custom function

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I am doing controller extension. I have the following doubt will you please solve my doubt. My doubt is how to pass the standard page filed data as an argument to custom function. Let us assume that in my standard page i have item details (it[More]

Essbase Error(1200400): scalar double argument expected in function [@EQ]

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am trying to launch a business rule that was validated successfully in EAS but when I launched it, it resulted in following error: Detail:Cannot calculate. Essbase Error(1200400): Error executing formula for [390202] (line 37): scalar double ar[More]

Error executing formula :scalar double argument expected in function [@DIV]

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm getting the following error when I try to run this calc. The syntax check says ok, but the calc won't run. I don't understand what the [@DIV] means ... Can someone help? Thanks! Error executing formula for [Alloc Factor] (line 0): scalar doub[More]

Variable number of arguments in C functions

Category:DefaultRelease time:-0001-11-30Views:130

Hello. I know how to achieve creating a function that accepts a variable number of arguments. For example: #include <stdio.h> #include <stdarg.h> int add (int x, ...); int main (int argc, const char * argv[]) int result = add(3, 5, 3, 7); prin[More]

Last argument in AGO function

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

How to pass default value of argument to stored function?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, in procedure I don't have to pass all arguments, because I set it with name, but in stored function I have to set arguments with index som I must set all arguments. Some arguments have default value. So how to pass default value? thx for any comm[More]

Maximum number of Arguments in Javascript function

Category:DefaultRelease time:-0001-11-30Views:130

Is there a way to handle large number of arguments to a Javascript function ? abhayHello, Well this is more a pure javascript question than a HTML DB you should ask google. But it depends what you are doing with your function, if each value is a spec[More]

Is it possible to pass an argument to the function triggered by an event handler?

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, Trying to migrate my way of thinking from AS2 to CS4/AS3. Ok, I have 2 buttons on the stage. Each button does almost the same thing, so I want to create a single function, and each button calls that same function (we'll name that function[More]

Passing an array argument to a function by referance

Category:DefaultRelease time:-0001-11-30Views:130

Below is my function I want to call my function but there seems to be an error in the way I am calling it can you tell me the right syntax to use? The function accepts 3 arguments an array of ints, an array of booleans and an int. I am calling it as[More]

Can not pass CString variable as value argument to exported function in library

Category:DefaultRelease time:-0001-11-30Views:130

I have extension library having following function exported __declspec(dllexport) int MyMessageBox(CString & csText, CString csCaption, const int iMsgType); The linker error is coming for second argument when I try to call the function from client.  [More]

Hot
Had to start Firefox in safe mode cause it kept crashing after i deleted the file. Now Fire fox Crashes every time I open it and I have to put it in safe mode just to use it, also it's not syncing with my iPad.If you use Norton software, try disablin [More]
I had just setup itunes on my second computer using the same account through home sharing and it all work well. I then bought an entire album from the itunes store with the LP. The LP automatically got on my first computer and is shown on my second. [More]
For some reason, Firefox will not open a new tab. It is happening on my desk top as well as my laptop. I noticed this problem today but have never had a problem up to this point. I cannot think of anything I have done differently to my computer.As no [More]
I was upgrading to 7.5 like a good boy when I get an error stating that "some necessary files are missing, to reinstall intunes." I have unistall and reinstalled several times both itunes & Quicktime with no success. Itunes will not open at [More]
HI Here with sending my req. Please give me the posible solution,its urgent, 1.     Get all the objects included in a transport request by using function module  /DGN/ITC_TRANSPORT_TO_OBJECT. 2.     Find the Objects which have the versions maintained [More]
Hello, For some reason,...the flash movie that I placed on dreamweaver 8 shows fine locally on this page,...but not when viewing it from the server..... The path looks fine. I've tried viewing in different browsers, and I cannot see the flash.. Link [More]
Hi i have created a unique index on table on 3 columns.I want to know when i have 2 records which contain same values in 2 fields and the 3rd field contains a null will unique index allow me to insert these records.Robert Angel wrote: This must be on [More]
Hi, oim v 11G I want to "use" the user password when provision to the DB . I have created a prepopulate adapter but then I can not seem to be able to connect this adapter to get the valuse form the user process. in the "data object informat [More]
Is the new photoshop compatible with photoshop 7 files?Do you mean can CS6 open files generated in Photoshop 7? Yes. To my knowledge without exception.Read other 2 answers [More]
I did try everything to get it work but no success. Started bootcamp and partitionned 200GB on my Fusion Drive. Bootcamp created my USB with a W8.1 Pro and the drivers. I replaced the driver with BootCamp5.1.5640 as my mac was listed to use this driv [More]