Variance Analysis With Native Versions Made Easy

2»

Comments

  • @shoaib986 

     

    I have not, but if you are using UX (not the classic dashboards), I think in the next couple of months you will have a nice surprise.

     

    Rob

  • 😍🤩

  • @rob_marshall some BI kind of Capability? 😄

  • @shoaib986 

     

    Variance Analysis via Management Reports.

  • 😍🤩

  • Megha27
    edited March 2023

    @rob_marshall Thanks for the explaination above. Would it be possible to use two LISS in the reporting module?

  • @Megha27

    Sadly, you can only have one line item subset (LISS) defined in the Applies To. With that said, you might want to consider creating a List from one of the subsets, get the data associated with that list via a mapping module, and then your reporting module will only have one LISS.

    Rob

  • Thanks for this great information. I wonder if there is a way that allows the Line Item to change its name dynamically as users choose their selection? ….🧐

  • Hi @rob_marshall this is very helpful! wanted to ask - in your exmple you're considering just one line item which is "data", but what happens when you need to do the version comparison for multiple line items? In the CALC 01 you'll have to create the version line items by each line item that you want to compare? thats the first thing that comes in the top of my mind right now.

    Appreciate whenever you have the chance to respond,

    Thank you!

  • @aerodriguezv

    It has been a while since I have looked at this, but you can have multiple metrics (my data) by creating a LISS at the beginning to consolidate the data.

    So, CALC01 would be dimensionalized by the LISS along with Products and Time. The "opportunity" you would then have is in Step 5 as you can't have multiple LISS in one module, so you could create a list containing your metrics, create a mapping from the new LISS Metrics to the List Metrics and go from there, and then include that list in the output.

    Hope this helps,

    Rob

  • Thank you so muxh @rob_marshall your comment helped a lot!

  • @aerodriguezv

    Good deal, happy to help.