Welcome to the Oracle Analytics Community

Home› Chez› Comments
Default Avatar
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Chez Rank 4 - Community Specialist

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…
    in Merging records from multiple data sets Comment by Chez March 2019
  • 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
    in Build bip template when xml have nested levels Comment by Chez March 2019
  • 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…
    in How to compare Period_name columns Comment by Chez April 2018
  • 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.…
    in How to compare Period_name columns Comment by Chez April 2018
  • 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…
    in Totalling by account and currency Comment by Chez April 2018
  • Thank you YG that script looks promising... will check it out tomorrow.... :-) Tam
    in Totalling by account and currency Comment by Chez April 2018
  • Thanks implemented your solution.. Now working.
    in Design of rtf template for multiple data sets Comment by Chez April 2018
  • Hi Adam I will have a look at the link and see if possible. Thanks C
    in Design of rtf template for multiple data sets Comment by Chez March 2018
  • 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
    in Design of rtf template for multiple data sets Comment by Chez March 2018
  • 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'…
    in Design of rtf template for multiple data sets Comment by Chez March 2018