Hello Angela,
Thanks for your reply. You seem to be the only SAS person around in the SAS Discussion Forums.
Unfortunately, we dont use Data Integration studio because the data is already ready in a staging database and I
dont see why to pay extra license fees so that the SAS OLAP cube understands my VALID_FROM and VALID_TO columns.
I see this as being a SAS OLAP Cube feature and if it is not there, then SAS OLAP is way behind its competitors.
Thanks for refering me to the paper but it does not tell me how to use my SAS OLAP cube (cube studio) with
a SCD, a dimension that is currently in an oracle datatable (having VALID_FROM, VALID_TO) date columns.