Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  difference calc between two members in same hierarchy

    Posted 08/09/20 09:13 AM

    Hi all,

    I am running CA 11 and using TM1 cubes as my data model, i am trying to create a variance report which looks like the below

    Version 1 Version 2 Difference in 2 versions Row1 Row2 Row3

    Version 1 and Version 2 are both elements from the same dimension but these are chosen by the users using a prompt so these can be any combination of any 2 elements in the version dimension.

    I am struggling to get around this issue and i feel it is something straightforward that i am missing.

    Any help would be greatly appreciated

    Thanks






    #CognosAnalytics
    #CognosAnalyticswithWatson
    #Support
    #SupportMigration


  • 2.  RE: difference calc between two members in same hierarchy

    Posted 08/09/20 09:14 AM

    Sorry this is what the report should look like






    #CognosAnalytics
    #CognosAnalyticswithWatson
    #Support
    #SupportMigration


  • 3.  RE: difference calc between two members in same hierarchy

    Posted 08/09/20 09:18 PM

    I also not make a difference between them and then I ruin my store long time ago.https://xxxtentacionmerch.net/category/hoodies/ for that store.






    #CognosAnalytics
    #CognosAnalyticswithWatson
    #Support
    #SupportMigration