Converts date strings to numbers that can be used in calculations.
Todate ( character_string_literal_1 ,character_string_literal_2 )
character_string_literal_1 | The format of the date string, either "mm-dd-yyyy" or "dd-mm-yyyy" (must be in lower case). |
character_string_literal_2 | The date string. |
For products introduced before 06.01.1996, the following query calculates a Revised Budget that is 110% of Budget.
WITH MEMBER [Scenario].[Revised Budget] AS 'IIF ( [Product].CurrentMember.[Intro Date] > TODATE("mm-dd-yyyy","06-01-1996"), Budget * 1.1, Budget )' SELECT {[Scenario].Budget, [Scenario].[Revised Budget]} ON COLUMNS, [Product].[200].Children DIMENSION PROPERTIES [Intro Date] ON ROWS FROM Sample.Basic WHERE ([Measures].[Sales], [Year].[Qtr3])
This query returns the grid:
Budget | Revised Budget | |
---|---|---|
200-10 | 11060 | 11060 |
200-20 | 9680 | 10648 |
200-30 | 3880 | 4268 |
200-40 | 2660 | 2926 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |