TI code for identifying unique new elements

[rvanlierop]

I am trying to import a text file that contains multiple instances of Purchase order numbers. Before adding these to an existing dimension I want to create a text file that will show unique instances of the PO numbers that are not currently in the dimension. This file contains data that is not filtered for PO.

[lotsaram]

1. Compare the PO number to the current PO dimension with DIMIX
2. If the PO does not currently exist insert it into a temporary dimension
3. Export the temporary dimension to a text file
3. Destroy the temporary dimension

[jim wood]

Or you can create a holding cube. Store them comma delimited in the cube for reference. (Do this by checking if there is a value already there. If not just store the PO number. If there is read the current value, append a comma then the new PO number.) If you do this based on the date that it ran. (Add the date to a date dimension in the holding cube.) you can keep an easily accesable record of new PO numbers and when they hit.

[rvanlierop]

Or you can create a holding cube. Store them comma delimited in the cube for reference. (Do this by checking if there is a value already there. If not just store the PO number. If there is read the current value, append a comma then the new PO number.) If you do this based on the date that it ran. (Add the date to a date dimension in the holding cube.) you can keep an easily accesable record of new PO numbers and when they hit.

Just to be sure I understand are you saying create a cube with a numbered dimension 1-10,000 and another dimension for holding PO number and import date?

[jim wood]

Apologies if I was a little vague.

Create a cube that has 2 dimensions: 1) Date. Just add one date to this. 2) A measure dimension that contains a text element.

In your dimension update process if you get a new element firstly insert the date in to the date dimension. Use Today(1) (Keeps the year to 2 digits) and dimension element insert for this. Also insert the data in a comma delimited format. The formula for this would look something like this:

Code: Select all

IF(CellGetS('New Element Deposit',Today(1),'text') @= ''
    ,DimensionElementInsert('Deposit Date', 1, Today(1),'S')
    ,''
   ) ;

IF(CellGetS('New Element Deposit',Today(1),'text') @= ''
    ,CellPutS(element_variable,'New Element Deposit',Today(1),'text')
    ,CellPutS(CellGetS('New Element Deposit',Today(1),'text')|','|element_variable,'New Element Deposit',Today(1),'text')
   ) ;

I hope that helps,

Jim.