11 Replies Latest reply on Nov 4, 2013 2:33 AM by Anand N.

    TB First not fetching correct values

    908557

      Hi All,

       

      I am encountering a problem while using a account member with TB First property. For your reference i have the data set below:-

       

       

      Unit1Unit1Unit1Unit1Unit1Unit1Unit1Unit1Unit1Unit1
      DC1DC1DC1DC1DC1DC1DC1DC1DC1DC1
      BU1BU1BU1BU1BU1BU1BU1BU1BU1BU1
      Scenario1Scenario1Scenario1Scenario1Scenario1Scenario1Scenario1Scenario1Scenario1Scenario1
      Act1Act1Act1Act1Act1Act1Act1Act1Act1Act1
      123456789Y-T-D(09)
      Product1Custom1134115580000000#Missing
      Product2Custom1242607934260793426079342607934307951417138241713824274650#Missing
      Product3Custom134877877648855924490715452695019231509395153636301538558417773170#Missing
      Product4Custom14432231.3432231.3432231.300000#Missing
      Product5Custom154.27E+084.27E+084.23E+0817082742162419021734719647537774753537#Missing
      Product6Custom164.55E+084.55E+083.9E+084.19E+084.16E+083.4E+083.43E+083.42E+08#Missing
      Product7Custom177.9E+087.9E+087.91E+088.23E+088.22E+088.16E+087.81E+087.79E+08#Missing
      Product8Custom183.36E+083.36E+083.3E+083.31E+083.22E+082.89E+082.91E+082.9E+08#Missing
      Product9Custom196.71E+086.69E+086.71E+086.64E+086.61E+086.55E+086.44E+086.41E+08#Missing
      Product10Custom1106.08E+086.08E+086.08E+086.4E+086.39E+086.34E+086.41E+086.38E+08#Missing
      Product11Custom1114.93E+084.93E+084.94E+085.16E+085.16E+085.13E+085.18E+085.16E+08#Missing
      Product12Custom1126.04E+086.04E+086.05E+086.34E+086.36E+086.3E+086.36E+086.34E+08#Missing
      Product13Custom1134.01E+084.01E+084.02E+084.07E+084.06E+084.03E+084.05E+084.08E+08#Missing
      Product14Custom1#Missing04.02E+084.01E+084.08E+084.06E+084.02E+084.03E+084.03E+08#Missing
      Product15Custom1#Missing#Missing#Missing#Missing#Missing#Missing4.98E+085.03E+085.01E+08#Missing

       

       

       

      The last column as you can see has #missing. The account "Account1" has property set to TB First and Skip None,Addition and Never Share. The account does not have any child members.

      The cube i am working on is BSO.

       

      Thanks and Regards,

      Kartik Gupta