Amicuk Programming Answers

Currency Conversion is not happenig in webform

-0001-11-30   Views:1


Hi, I have created three more members in period dimension along with BegBalance and YearTotal. My period hierarchy looks like this. Period BegBalance YearTotal Q1 Q2 Q3 Q4 2008 Actual thru Sept (Formula: = Actual->Q1 + Actual->Q2 + Actual->Q3;) E

I have created three more members in period dimension along with BegBalance and YearTotal.
My period hierarchy looks like this.
2008 Actual thru Sept (Formula: = Actual->Q1 + Actual->Q2 + Actual->Q3;)
Estimated Oct-Dec 2008 (Formula: = Budget->Q4;)
Estimated Total Cost 2008 (Formula: = "2008 Actual thru Sept" + "Estimated Oct-Dec 2008 ";)
First tell me can we craete more mebers like this in Perion dimension?
I have created the above members and tagged a formula to it as shown in braces.
Now my problem is data is coming for local currency only. When i change my currency, YearTotal members are converting but these newly added members are not converting and showing blank fileds.
My doubt is can we add extra members like above in period dimension?
Whether currency conversion happens to formula tagged members also?
If yes, what could be the problem in my scenario?

The replay answer
I suspect that your currency conversion business rule is excluding these new members. It was probably created before the new members were added. (I don't have a standard FX conversion rule in front of me, but I think it fixes on specific time periods - I could be wrong. ) You can either:
1) Make sure your new Period members are in fact included in the currency conversion business rule and re-run that script.
2) Make your new time period members dynamic. (and not have to worry about currency conversion and what calc's first (your new members vs. the FX conversion))
I would try #2 first, as it's a quick fix. Just switch the data storage, refresh the cube, and re-test.
I assume you have Period and Accounts as Dense, with the remainder of your dimensions Sparse. Is this correct?
Let me know how it goes.
Hope this helps,
- Jake

Go to See the other 5 answers

Currency Conversion is not happenig in webform

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

Hi, I have created three more members in period dimension along with BegBalance and YearTotal. My period hierarchy looks like this. Period BegBalance YearTotal Q1 Q2 Q3 Q4 2008 Actual thru Sept (Formula: = Actual->Q1 + Actual->Q2 + Actual->Q3;) E[More]

End routine for Currency conversion

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a requirement in which i have to convert sales and cost into three types of currency as GBP, INR and EUR in cube. i made 3 different fields for sales as well as for cost. But i am unable to write end routine for it. Can anyone please help[More]

Currency Translation Type in queries using currency conversion

Category:DefaultRelease time:2015-10-11Views:130

I have a question on the Currency Translation Type (EUR_VAR) that is used in all of the queries using currency conversion on the fly. (currency is maintained automatically nor in table.) User wants to use 2 different exchange rates in a single query.[More]

Currency Conversion  on Piticular date

Category:DefaultRelease time:2015-10-11Views:130

Dear All,                I have a requirement where in I have to convert the  Purchase Document Currency into USD on  PO Creation Date. I did the Currency Conversion in the BEX by creating a currency translation type using the tcode RSCUR. Following[More]

Help needed with Include ZXRSRU01 in relation with currency conversions

Category:DefaultRelease time:2015-10-11Views:130

I'm implementing how to paper: Use variable time references in currency conversions (BW 3.3). When implementing variable exit RSR00001 & write include ZXRSRU01 an issue pops up. The relevant code is: <i> DATA: l_s_var_range TYPE rrs0_s_var_range[More]

Currency Conversion in WebI Report

Category:DefaultRelease time:2015-10-11Views:130

Hi All: Need your help in currency conversions using WebI Report. Current Scenario:      Currency conversions are currently achieved at BEx Query Designer level where target currency is determined through a Selection Variable. Proposed Solution:    A[More]

Issue regarding currency conversion

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I'm having issue with currency conversion. Default report output values are displaying in 'EURO' and I had created a toolabar with currency conversion buttons. When this button is selected, values has to be changed into user select curren[More]

Currency conversion error in SAP HANA

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am new to SAP HANA and learning to create information views in HANA studio (SAP HANA SP6 on Cloudshare, HANA studio 1.0.68). I am trying to create a simple analytic view (on purchaseOrderItem table in SAP_HANA_EPM_DEMO sample database) to have[More]

Error during currency conversion and consistency check in a sales order

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I am facing the below error in the sales order. The sales order is having so many items. The below error is coming for few items only. I have checked the currency exchange rates also. All are maintained properly. Please advice me how to f[More]

Credit memo request with currency conversion to EURO

Category:DefaultRelease time:2015-10-11Views:130

I have a requirement in which i need to create a Credit Memo Request for the newly created sales organisation using the old billing document number created for old sales organisation.New sales org will have its currency changed to EURO.I referred to[More]

Local Currency conversion in PO

Category:DefaultRelease time:2015-10-11Views:130

Hi Iam facing problem in wrong Local currency conversion while doing GR reversal for foriegn currency Subcontract PO. Local Currency : EUR PO Currency     : HUF User has entered wrong Exchange rate in OB08. (Indirect Quotation : HUF -> EUR) & did G[More]

Hi experts, I have to create a form for dunning letter with (smartforms) for the transaction F150 and really I don't know how I will do it. I don't know how to pass the fields run on, identification customer to the formulaire for getting data for dis [More]
I've been trying to figure out if i can use my American Express Gift Card to buy music on iTunes and im starting to think i can't. Anyone know if i can? Or how to do that (if so)? Windows XPGo to Best Buy or Circuit City, wherever you like. Use the g [More]
i need to call a method with a series of String parameters what am i doing wrong? the java     public ArrayList getEmployeeSkills(String ename, String snmae, String yearsexp)the jstl     <jsp:useBean id="empskill" class="com.Database.Emp [More]
I upgraded from XP to Win 7 Ultimate. When I try to install the Win 7-compliant driver from the Lenovo site, the OS tells me that it's not compliant and "fixes" the problem by installing generic drivers that, of course, don't allow me to modify [More]
I am making a play list for a Halloween party and I am including some scary sound effects. Some of the sound-effect files are rather lengthy, so I want to play only part of them at a time. What I have done is to put the same scary song on the list se [More]
HELP!  I am trying to download Photoshop Elements 11, that I purchased via Adobe internet. It started to load, but in the final stages it asked for me to close ElementsAutoAnalyzer.exe, dynamiclinkmanager.exe   I don't know where to go to do this. I [More]
Hi everyone ! I am using CS3 with the latest Camera RAW. After applying a crop to a RAW file, there is no "OK" or "APPLY" button in order to change various setting only on the cropped/final image. Does anyone know a way to alter settin [More]
Hi Friends, For Material- 10001000, I can find the 543 movement. But there is no 541. Details: Subcon PO- QTY-50 for parent mat- ABCDEFG. Components maintained  - 100 pcs of “COMPABC” The issue is: -     I didn’t issue 100 pcs of components (541) to [More]
I have configured all the benefits plans but i want to configure cobra plan for maintaining infotype 0212. Can you tell me the steps for configuration. thanksFollow the img path steps for COBRA Plans: In this step, you specify which health plans that [More]
forms 10g i use this : READ_IMAGE_FILE('D:\ftpweb\LocalUser\imedia\' || 'f_' || :B0.CODICE_CASA || '_1.jpg' , 'jpg', 'b3.foto1'); it is all ok if the image file is on the web server, but if the image is not present on the web server the form crash !! [More]