Databases Reference
In-Depth Information
Next we join the month and year columns using the column join option in the
Data Source Properties
screen as shown:
Observe how we told Essbase to join columns 1 and 2 into a new single column.
But wait, the date format is still wrong. What do we do next? Easy enough, all we
need to do now is set up the replace function to convert the date column into an
Essbase-friendly date format. Watch how easy it is:
