This is one of the more odd requests I have had for a while, so I thought I would document the solution.
We have a customer who wants under certain conditions create all combinations from the certain G/L Account No. concatenated with some dimension value... so he can create a reporting dimension...
so from the account no.
And list of dimensions
He would like to have rows created in the staging area of
Can we do this in TX ? if so, how ?
Note: As added information, there is no join between the tables.
The easiest way is to create a custom view using the following syntax.
CREATE VIEW [dbo].[vAccountDims] AS
SELECT [AccountNo] + '-' + DimID AS AccountDim
FROM [dbo].[Accounts_V] A, [dbo].[Dims_V]
With data as per above, the results of the view looks like this:
I have attached a project in timeXtender 4.5.37 format as a reference. Please be aware that this might not load in all future versions of timeXtender.