mercredi 27 juin 2012 07:01
I have to get quarter attribute as April-June 2010(firstmonthofquarter - lastmonthofquarter year). Presently i have quarter values 1,2,3,4. Is this possible?
Toutes les réponses
mercredi 27 juin 2012 07:12
You can edit the DSV to create a named query.
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
lundi 2 juillet 2012 09:15Modérateur
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
Expression: EnglishMonthName+' '+ CONVERT(CHAR (4), CalendarYear)
For more information about defining Named Calculations in a Data Source View, please see:
TechNet Community Support
lundi 2 juillet 2012 10:21
But i have to define it as FirstMonthofQuarter - LastMonthofQuarter Year. I don't it is possible with Named calculations