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
hi we have configured simple credit check for ZOR and with delivery block. since TAD is order related billing even though credit limit exceeds they can bill the customer.Now I have to configure simple credit check for serive orders with item category [More]
i ve prepared a service entry sheet for which i ve made the payments to the endor, can still cancel the order after the payment has been madeits possible, before MIRO reversal reset the cleard item , reverse the MIRO and cancell and delete the servic [More]
When trying to install Firefox 3.5 I get the following error...The operation cannot be completed because you do not have sufficient privileges for some of the items. I am logged in to the administrator account. Any suggestions?Thanks sig. It was when [More]
Safari won't load certain pages, times out, and Software Update stalls. Have reset Safari, emptied cache, etc. but no change. May be more pervasive than just Safari. What to do next? Console log: 2007-02-20 22:26:35.297 System Preferences[343] * -[NS [More]
Dear Pals, My N9300i Phone takes more time to update and some time hangs also. Then i have to switch off and restart to solve the problem. Please help meHi Rajkumar. Is the source for your prompt a fact table or a dimensional table? Do you have index [More]
I'm using a Lenovo ThinkPad, Windows 7 pro, 64 bit. Loading a jpeg, all Parameter of the Monitor are used. Loading a RAW-file, not.So where are these Forum experts????? Here is the chat support. What a joke!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! system: PC [More]
A few years ago I had transferred home videos from 8 mm tapes to DVD, because I was afraid the tapes would disintegrate if I waited any longer. Now that I finally have time to edit these DVDs I discover that I cannot import them on iMovie, because th [More]
I downloaded the newest version and it still won't work on my computer, what do I do? I even tried all the adobe troubleshooting!Post in Adobe forums since its their product. Read other 3 answers [More]
Hello, i have a problem with Bridge CS6. Somehow its very slow and lags. when i tried to open a folder it takes sometimes several minutes before anything happens. is there a way to reset bridge to its default settings without reinstalling? ThanksWhat [More]
What kind of difficulties will I encounter if I purchase a pc keyboard for use with my new mac mini.  Does if make a difference whether wired or wireless? Thanks, OwenThe only difference I found with a PC KB is the Windows logo key  is the Command ke [More]