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.
Delete string (text) data using TI process
-
Christopher Kernahan
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
Re: Delete string (text) data using TI process
Hi,
Why don't you put your TI code up so we can have a look through it.
Are you building the views in the TI process? If so, is it flexible enough to know not to add Product A and B if there is no longer any data?
Why don't you put your TI code up so we can have a look through it.
Are you building the views in the TI process? If so, is it flexible enough to know not to add Product A and B if there is no longer any data?