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
Hello, I use PS6.1 on a server with more domain names. If I login to one domain many portal links are directed to other domain. I suppose that there is something wrong in function/tag getDesktopURL(). The domains are swaped sometimes after server res [More]
Hi I seem to get error messages when I try to sync with itunes. I have the iphone 3G. Also all my music and videos seem to have carried across, all except one, it's very odd. Latest error message reads: "itunes could not connect with the itunes store [More]
Everything was working fine under Windows 7.  Outlook 2010 and IPad Contacts and Calendar were syncing perfectly.  Once Windows 8 was installed problems arose.  If I entered or updated a Contact or Calendar item in Outlook 2010 it synced perfectly wi [More]
I would like to change the screen background color using the Framed color box.  I can do this using property node. The problem is I cannot update the screen simultaneously as that in VI edit mode. I hope the screen background color can update as the [More]
Hi, I am trying to use jstat and jmap utilities to get the snapshot of the jvm. It is working fine in dev and staging env but it doesn't work in production. All three on linux. The error is could not find jvmId. The main difference i found is that th [More]
can u tell me exactly when will we use co related sub queries instead of sub query? and writing a select statement in veiw instead of self join? please let me know this clearly ..Hello Do you understand the difference between a correlated subquery an [More]
I love my TravelDock, but I have a minor issue. When the MicroPhoto is docked in the TravelDock, and then connected to my computer via the USB connection in the rear of the TravelDock, the computer does not detect anything. I have the TravelDock and [More]
Hi experts. I implement JRF-WS client that will be secured using SSL. I set the proper Java System properties: javax.net.ssl.trustStore=<path to truststore> javax.net.ssl.trustStorePassword=<password to truststore> How should I store the passw [More]
We have created single Business Service which is getting called from one proxy service to execute different Web Service end points. For different end point execution I want to pass different authentication parameters. Currently we have configured Use [More]
I have updated Bridge I have resetted prefs. It happens in both CS4 and CS5 any ideas? Mac 10.6.8and its odd it happens in the CS4 also That is indeed the weird thing but to me this seems also the reason to first look at you OS system itself because [More]