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
Dear Team, I joined BT recently this month and I have a btinternet Email for more than 5 years when i was living with my brother. Now I want to tranfer my email from my brothers account to my account and make it my primary email. I called 3 times the [More]
Hi everyone, I have had a Droid 3 phone for a few months.  When I first recieved my new phone from the retailer, it had some simple OS malfunctions like resetting my wallpaper and restarting a couple times.  It only lasted consistantly for a couple d [More]
The ipod icon does not appear on itunes. I followed all the troubleshooting  help.  Uninstalling all programs related to ituens and itunes.  veryifying uninstall restarting  computer, installing again.  I bought this ipod at a thrift store.  BUT IT W [More]
Hi Folks, My new 23" Cinema Display has arrived. That's the good news. Of course I checked Apple's site before the purchase, to be sure the new monitor would work with my very old G4. As soon as I saw the line under System Requirements where it said [More]
Hi, I've a project to control two separate applications (C++ and LabView) and both of them are implemented as server. Another client program (C++) is used to control those application. The communication among them are implemented using TCP socket. Th [More]
Does anyone know why this would be happening? My mac mail will not search mail anymore and doesn't load attachments most of the time.  When I enter some text in the search box no results come up and I know there are messages that contain the phrase t [More]
Have a strange situation on IMAP. My phone. 1. If I delete on my iPhone: a) The message is copied to a Deleted folder b) The message is deleted from the Inbox c) An expunge is sent immediately and the message has totally left my Inbox 2. If I mark as [More]
Hi there, I just bought my first ipod touch. I was just holding it in my hand while music was playing on it, and I was glancing at my computer monitor and reading something. Then I looked back at my ipod and I noticed a menu I had never seen before. [More]
I just learned that my G4 cant upgrade to 10.5 and thus I cant supposedly use the itunes store anymore, anybody have infos on how to deal with this without having to buy a new PC or laptop? thanksYou can upgrade to 9.2.1 but that is still pretty out [More]
When creating a purchase order from the SAP, we have a partner that should get the Layout in PDF of the Purchase order via Email, when sending it to this email, the partner get this email however: 1. if the partner looks at Outlook he can see email a [More]