Welcome to the Oracle Analytics Community

Products Banner

Chez ✭✭✭

Comments

  • Hi Suresh Thank you for your response. I cannot change the source as it is seeded source so I have to try and find a way to get to records producing 1 record with values summed up. I am not following you on your first suggestion of 'try insert summary columns at the end using…
  • Thank you for your post Suresh. I was however able to achieve what I wanted with the following command. <?if:number(../../SORT_FIELD2)<2000 and TOTAL_CUST_AMT != ''?> Regards Cheryl
  • Hi YG How can I add this logic in the data model.... can you assist on how code is written to say that if a month like Jan-18 which is newer than the parameter month of Dec-17 to not include these records? However I would prefer to try and manage it on template if possible.... as I need both income statement and balance…
  • I am looking at the link sent through but not seeing a method that I can use.... Please if there are any suggestions on how I Can do this it would be really helpful.... the balance sheet accounts are all of account type A, L and O... and Income Statement are E & R... this value is in my xml as well... any ideas please.…
  • Hi YG, I was trying to group by ACCOUNT and then by CURRENCY. I have now been able to get this working correctly. Thank you very much for your quick reponse. I am now however battling to bring in the beginning balances for a custom report from gl. The beginning balances as far as I can see is sititng on the gl_balances…
  • Thank you YG that script looks promising... will check it out tomorrow.... :-) Tam
  • Thanks implemented your solution.. Now working.
  • Hi Adam I will have a look at the link and see if possible. Thanks C
  • Hi Carlos I have now attached to xml sample and rtf. Would appreciate your input to see if it can be done within the template. Thank you kindly C
  • Hi Adam The only link I can find is that of <INV_ACCT_DESCRIPTION> from the <G_INVOICE> data set that has the same value of the <CUST_NAME_INV> from the <G_CUST_INV> data set. I cannot however join them in the data model as we are using seeded data model and scope to change this is not possible. I must find a way to 'join'…
  • Hi Carlos Would prefer to email direct if possible? :-) Thanks C
  • Hi there Can I please send it to your email address and if so could you share your address with me please? Thanks Cheryl Cheryl Kleu Independent Contractor T +27 11 5758645 M +27 83 2229644 Echeryl.kleu@britehouse.co.za…
  • Hi Thank you for your response. I have now tried that but it still pulling null values. I am not sure if it is because the template also have other commands built in. Would it help if I sent you the rtf for review? Kind Regards Cheryl Kleu Independent Contractor T +27 11 5758645 M +27 83 2229644…
  • Hi Thanks for your feedback. I cannot change the code. Seeded code is being used. Was hoping to get around it in the custom template. The data set is used in the seeded template but not as part of the detail data. It is part of the header data. Thanks Cheryl
  • Thank you Brajesh... I got this working using your method... eventually figured it out.... :-)
  • Hi Brajesh Thank you for your response. I am not sure I understand this method. One invoice could have 5 lines ones or maybe the next time it could have 7 lines or the next it could have 25..... so how many lines do I put into the footer?? Please can you advise. Thanks Tam