locked
Performance point 2010 issue..? RRS feed

  • Question

  • Hi.,

                     I had a small issue to fix  regarding Time intelligence connection formula..

    In performancepoint 2010 i need to retrive data based on week basis .., means if i select Date as 01/01/2012., the output must be

    data for the whole week preceding by previous three weeks and next three weeks of selected week..

    therefore i will get totally 7 weeks in the chart with selected week in the centre...

    My formula is  Week-3,Week-2,Week-1,Week,Week+1,Week+2,Week+3

    I got the out put.,

    But the issue is when i select 2012  weeks the output is correct.., means the selected date week output is coming at center with -3 week,selected week,+3 weeks.., here i give Time intelligence settings as 2012 Year..for data connection.

    when i select  2011 week the out put is incorrect.., means the selected week of 2011 is not coming at center.,

    it coming as -4,selected week,+2 weeks...,

    same problem for 2010 the output is -5,Selected week,+1 weeks..,

    The output is correct for the year which i had given in time connection..

    Please suggest the necessary solution for teh issue.

    Thanks,

    Avula.GK


    Avula.GK

    • Moved by Elvis Long Thursday, October 11, 2012 8:41 AM better support (From:SQL Server Analysis Services)
    Monday, October 8, 2012 5:44 AM

Answers

  • I got the answer finally...,

    Its jus a formula mistake...

    Day-3.Parent:Day+3.Parent does the work for me..

    Thanks,

    Avula.GK


    Avula.GK

    • Marked as answer by Avula.GK Thursday, December 13, 2012 2:51 PM
    Thursday, December 13, 2012 2:51 PM

All replies

  • Hi.,

                     I had a small issue to fix  regarding Time intelligence connection formula..

    In performancepoint 2010 i need to retrive data based on week basis .., means if i select Date as 01/01/2012., the output must be

    data for the whole week preceding by previous three weeks and next three weeks of selected week..

    therefore i will get totally 7 weeks in the chart with selected week in the centre...

    My formula is  Week-3,Week-2,Week-1,Week,Week+1,Week+2,Week+3

    I got the out put.,

    But the issue is when i select 2012  weeks the output is correct.., means the selected date week output is coming at center with -3 week,selected week,+3 weeks.., here i give Time intelligence settings as 2012 Year..for data connection.

    when i select  2011 week the out put is incorrect.., means the selected week of 2011 is not coming at center.,

    it coming as -4,selected week,+2 weeks...,

    same problem for 2010 the output is -5,Selected week,+1 weeks..,

    The output is correct for the year which i had given in time connection..

    Please suggest the necessary solution for teh issue.

    Thanks,

    Avula.GK

        


    Avula.GK

    • Merged by Elvis Long Wednesday, October 10, 2012 10:43 AM duplicate issue
    Sunday, October 7, 2012 7:56 AM
  • Hi.,

                     I had a small issue to fix  regarding Time intelligence connection formula..

    In performancepoint 2010 i need to retrive data based on week basis .., means if i select Date as 01/01/2012., the output must be

    data for the whole week preceding by previous three weeks and next three weeks of selected week..

    therefore i will get totally 7 weeks in the chart with selected week in the centre...

    My formula is  Week-3,Week-2,Week-1,Week,Week+1,Week+2,Week+3

    I got the out put.,

    But the issue is when i select 2012  weeks the output is correct.., means the selected date week output is coming at center with -3 week,selected week,+3 weeks.., here i give Time intelligence settings as 2012 Year..for data connection.

    when i select  2011 week the out put is incorrect.., means the selected week of 2011 is not coming at center.,

    it coming as -4,selected week,+2 weeks...,

    same problem for 2010 the output is -5,Selected week,+1 weeks..,

    The output is correct for the year which i had given in time connection..

    Please suggest the necessary solution for teh issue.

    Thanks in advance..,


    Avula.GK

    • Merged by Elvis Long Thursday, October 11, 2012 8:38 AM duplicate issue
    Sunday, October 7, 2012 9:16 AM
  • Hi Avula,

    This issue is more related to PerformancePoint Services. For better support, I moved this thread to PerformancePoint Server Forum.

    Thanks for your understanding.

    Regards,  


    Bin Long

    TechNet Community Support

    Thursday, October 11, 2012 8:36 AM
  • First thing to check would be Time tab under Data Source. The Mapping has to be correct for the reference date. Make sure the dates (latest) exists in the cube to which you are referencing.

    http://dailyitsolutions.blogspot.com/

    Friday, October 12, 2012 2:07 PM

  • Avula.GK

    I think everything is correct according to my knowledge..

    or if you advice i will follow in different way..

    So,please do the needful..

    Thanks,

    Avula.GK


    • Edited by Avula.GK Friday, October 12, 2012 5:59 PM
    Friday, October 12, 2012 5:56 PM
  • Try setting this reference date to today's date and verify.

    http://dailyitsolutions.blogspot.com/

    Monday, October 15, 2012 2:38 PM
  • Hi Khan.,

          But still in vein.,

    Cannot slove the issue.

    Please suggest solution .,

    Least suggest how to change the date format of date picker for performance point content time inteligence date filter., in sharepoint 2010.

    Thanks,

    Ganesh.

      


    Avula.GK

    Tuesday, October 16, 2012 4:34 AM
  • Hi Khan.,

                   Got the solution... for week analysis.., Think its a formula issue... I changed it to..         Day.Parent-3:Day.Parent+3  It worked.

    Please suggest how to change the  Date format in PPS content.

    Thanks,

    Avula.GK...

         


    Avula.GK


    • Edited by Avula.GK Thursday, October 18, 2012 7:01 AM --
    Thursday, October 18, 2012 7:00 AM
  • Hi khan.,

    I had much more doubts can u share your mail id  please.

    umir.khan@t4g.com

    got from froum..but its vein..,

    Pleas share yours personal mail id.. to my id ganeshkumar.a@solverminds.com

    Thanks in advance.,

    Avula.GK


    Avula.GK

    Thursday, October 18, 2012 10:54 AM
  • I got the answer finally...,

    Its jus a formula mistake...

    Day-3.Parent:Day+3.Parent does the work for me..

    Thanks,

    Avula.GK


    Avula.GK

    • Marked as answer by Avula.GK Thursday, December 13, 2012 2:51 PM
    Thursday, December 13, 2012 2:51 PM