Quarter desc attribute!

Toutes les réponses

• mercredi 27 juin 2012 07:12

   

   
  

  0

  You can edit the DSV to create a named query.

  Named Query: http://msdn.microsoft.com/en-us/library/ms175683.aspx

  It would be great if you can elaborate more.

  ---

  Please vote as helpful or mark as answer, if it helps
  Cheers, Raunak | t: @raunakjhawar | My Blog

  • Réponse
  • Citation

   
• lundi 2 juillet 2012 09:15

  Modérateur

   

   
  

  0

  Hi Eshwar,
  
  In your case, I think that we can add a new named calculation in a Data Source View. Please refer to the following example about the named calculation:
  Column name: CalendarQuarterDesc
  Description: Null
  Expression: EnglishMonthName+' '+ CONVERT(CHAR (4), CalendarYear)
  
  For more information about defining Named Calculations in a Data Source View, please see:
  http://technet.microsoft.com/en-us/library/ms174859.aspx
  
  Thanks,
  Bin Long

  ---

  Bin Long

  TechNet Community Support

  

  • Réponse
  • Citation

   
• lundi 2 juillet 2012 10:21

   

   
  

  0

  Thanks lot..

  But i have to define it as FirstMonthofQuarter - LastMonthofQuarter Year. I don't it is possible with Named calculations

  Regards,

  Eshwar.

  • Réponse
  • Citation