Delete string (text) data using TI process
Posted: Thu Nov 17, 2011 5:09 am
Hi,
I need to zero out both text and numeric data in a cube by using TI process. The 'ViewZeroOut' function works in deleting both text and numeric data. However, when I open the cube, those cells used to have data before running the TI process still appear in the cube. It seems that suppress zero function does not work here. Let me explian in details:
The cube has 3 dimensions
- generic numbers (i.e. 1 to 100) to represent shipments
- product list
- measure (vessel name, volume and etc).
So basically, for the current forecast, shipment 1 can carry 100 units (numeric data) of Product A and B by Vessel 'Today' (text data). When we do next forecast, shipment 1 may carry Product C and D by vessel 'Tomorrow'. The TI process can successfully delete 100 and Today from Shipment 1. But when I load the new forecast in, shipment 1 will have Product A, B, C and D appearing in the view, even there's no data at all for Product A and B. Is there anyway that I can somehow remove Product A and B completely from shipment 1 by using a TI process.
Your help will be much appreciated.
I need to zero out both text and numeric data in a cube by using TI process. The 'ViewZeroOut' function works in deleting both text and numeric data. However, when I open the cube, those cells used to have data before running the TI process still appear in the cube. It seems that suppress zero function does not work here. Let me explian in details:
The cube has 3 dimensions
- generic numbers (i.e. 1 to 100) to represent shipments
- product list
- measure (vessel name, volume and etc).
So basically, for the current forecast, shipment 1 can carry 100 units (numeric data) of Product A and B by Vessel 'Today' (text data). When we do next forecast, shipment 1 may carry Product C and D by vessel 'Tomorrow'. The TI process can successfully delete 100 and Today from Shipment 1. But when I load the new forecast in, shipment 1 will have Product A, B, C and D appearing in the view, even there's no data at all for Product A and B. Is there anyway that I can somehow remove Product A and B completely from shipment 1 by using a TI process.
Your help will be much appreciated.