Comments

  • 1-10 of 10
  • Vatsal Gaonkar

    Hi Shraddha,

    Essentially the Smart list to Dimension mapping always assuming that you have smart list defined for every intersection in the source to push. If it comes up with no smart list values in the source then it asks for a #missing label to push the data for source. It looks like the data mappings are pushing data for which there are no smart list values (which is for all your data being pushed), hence you end up getting all your data pushed into the #missing label member in the target. 

    Can you ensure that your pull from source has smart list values per intersection? A Smart View grid should give you the answers on your source data. 

    I would be interested to know in what you find. I have a few of these smartlists to dimension data maps/ smart pushes myself and would like to know for some reason there is any technical issue now outside of a data map definition. 

    Vatsal

     

     

  • Vatsal Gaonkar

    Hey Pete, 

    I had to reach out to the team to understand how successful they were in getting the export data slice to work. Here are some of their feedback - 

    1) A total automation was never attained - truly what the team did was export using a REST client such as ARC and then saved the JSON file to get the JSON Grid

    2) The largest data set they were successfully able to export is 200KB

    3) It takes a lot of trial and error to get JSON export

    4) Member call-outs should exclude shared members in the hierarchy - in other words, choose stored member hierarchy for Descendants / Idescendants member call-outs

    Given the above, I think the quick and straight-forward way has to be to provide an ability to use a REST call or EPM Automate command to call Export Level0 from ASO plan types in EPM Planning cloud. Please log your idea and provide us a link here and then I will give it a thumbs up!

  • Vatsal Gaonkar

    Hey Pete, 

    Have you tried to export data slices? There is a REST API call for it. We have used it successfully. Please note that the data slices come out in the JSON format - in other words it will then need to be imported in that very format using the Import Data Slices functionality.

    https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/export_dataslices.html

    To answer your question directly though - there isn't a way to run the Level 0 export specifically using a REST API / EPM Automate call and hence it might required a bit of doctoring (rules file) to get into the on-prem. cube using a JSON file. 

    If I see your Idea, I will give a it "Thumbs Up"

    Vatsal

  • Vatsal Gaonkar

    As soon as I get some updates that are ready to post here in this forum, I will post them. 

    Thanks, 

    Vatsal

  • Vatsal Gaonkar

    Hi Manish, logged a SR - 

    SR 3-20576207821 : EPM Connection artifact performance degradation

     

    Thanks

    Vatsal

  • Vatsal Gaonkar

    If you are sure that the behavior is different from when they were before, I would log a SR. I typically put rules on the form and then for dashboard design ask to run the rules from the form as opposed to call the rules artifacts themselves. 

    Vatsal

  • Vatsal Gaonkar

    I would attach the rules to the constituent forms with the selections for "before save", "on save", "use members from form" etc. and then call them from dashboard to run the rules on the form. I have had success with this methodology. Let me know what happens when you do the above.

    Vatsal

  • Vatsal Gaonkar

    Are you asking the dashboard to run the rule from form as opposed to attaching the business rule to the dashboard itself? 

     

     

  • Vatsal Gaonkar

    Hello Anthony, 

    You hit it on the head. You were right, this domain has multiple services and they have some of these services earmarked for FCCS and some for Planning. There is no telling which one is for which given that it has HyperionPlanning extension on all. I could make a planning connection to one of the anointed planning services. So the connections are backsmiley for what I am trying to do. 

     

    Thank you

    Vatsal

     

  • Vatsal Gaonkar

    In addition to what Mark is stating here are some considerations for your BSO to ASO conversion - 

    1) Time Balance - ASO will not have time balance conversion from BSO to ASO. Best practice is to create another dimension to house a Load member, and other time balance members such as QTD, YTD, HTD and so and so forth. In some implementations I have built alternate roll-ups in the time periods dimension, but found this approach cumbersome while dealing with average and first time balance formulae

    2) Consolidation operators - Very important to keep in mind the position you are stating in question/ statement.

    3) BSO member formulae to ASO MDX member formula conversion - you will have to convert all your BSO member formulae to ASO MDX formula

    4) Mark has already pointed you to the business rules conversion section

    5) Merging of data slices - It is best to merge data slices in the ASO plan type to ensure optimal performance in addition to the aggregate views - https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/prest/pbcs_merge_data_job.html

    Hope this helps 

    Vatsal