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
My iPod touch 4th gen is at ios 6.1.3 and I want to know when I can update it to a ios 6.1.46.1.4 is for the iPhone 5 only.Read other 3 answers [More]
First off, I'm running on windows XP and Internet explorer 8. I've tried multiple times to download the latest flash player. However, each attempt had ended in failure. I've done everything suggested on the help page; I have downloaded the uninstalle [More]
Hi All, I uploaded planned values by cost center and then I ran a  gl report by profit centers to check if cost center values rolled up to New GL(ECC6.0),The planned values was not there so I had to execute program FAGL_CO_PLAN ,after executing that [More]
Hi Everyone, We have an RDS 2012 setup, using 2 Hyper-V systems to provide Virtual Machines. We have recently changed from a flat network, and have now VLANed the network.  During this process, we put the Virtual machines on a separate VLAN from the [More]
Why do i keep getting a notice from Itunes saying: "The Itunes library file cannot be saved. You do not have enough access privileges for this operation" every time i add music my Itunes library?Hello deborahjael, Thanks for using Apple Support [More]
Ok i am about to distroy my computer for real, Ok when ever i want to burn a project gets all the way to the end, i get multipexing errors or error #1 everytime. Anyone know the deal or easy fix?Hi Jonathan Was Your Mac delivered with Mac OS X.4.2 an [More]
I am trying to convert a 1-color drawing to a path so I can put it into Illustrator. I use the magic wand to select the edges and get a nice tight fit. But when I select the "Make work path from selection" button, I get a sloppy fit. I've looked [More]
I restarted my computer one day and it booted into a Black screen (Darwin/BSD). I've tried the suggestions on various forums below: http://missionitgroup.com/blog/?p=1490 http://discussions.apple.com/thread.jspa?threadID=320663 But I am still unable [More]
Dear guys, we are faced with the following situation: Customer uses MS Office2003 and BI-AddOn7.x (Patch 3). We have to provide him workbooks but we use Office 2010 and BI-AddOn7.x (Patch 3). If we now provide the workbook our customer cannot open th [More]
Hi all, First we do not activated the credit check at Delivery and PGI levels. But in case of export scenarios we are using LC documents, and these documents are some times attached to delivery and some times to sales order. Case1: The sales order is [More]