As we have ViewZeroOut() function to zero the numeric values in a cube, Is there any specific function to clear the string values in a cube?
Thanks in advance.
How to clear string values from a cube.
-
ryan
- Posts: 59
- Joined: Thu May 26, 2011 5:04 am
- OLAP Product: COGNOS
- Version: 9.0
- Excel Version: 2007
How to clear string values from a cube.
Configuration Details
Microsoft Window Server 2003 Exterprise x64 Edition Service Pack 2
RAM 32 GB
using IBM Cognos Express Xcelerator (Version 10.1)
MS-Office Excel 2010 (12.0.6514.5000)SP2 MSO (12.0.6425.1000)
Microsoft .NET Framework 3.5
Microsoft Window Server 2003 Exterprise x64 Edition Service Pack 2
RAM 32 GB
using IBM Cognos Express Xcelerator (Version 10.1)
MS-Office Excel 2010 (12.0.6514.5000)SP2 MSO (12.0.6425.1000)
Microsoft .NET Framework 3.5
-
Gregor Koch
- MVP
- Posts: 263
- Joined: Fri Jun 27, 2008 12:15 am
- OLAP Product: Cognos TM1, CX
- Version: 9.0 and up
- Excel Version: 2007 and up
Re: How to clear string values from a cube.
Uhm, no. Not that I am aware of.
But maybe this
http://www.tm1forum.com/viewtopic.php?f ... 94&start=0
and that
http://www.tm1forum.com/viewtopic.php?p=9951
gives you more information. Those are just the first two hits if you search for 'viewzeroout string'.
But maybe this
http://www.tm1forum.com/viewtopic.php?f ... 94&start=0
and that
http://www.tm1forum.com/viewtopic.php?p=9951
gives you more information. Those are just the first two hits if you search for 'viewzeroout string'.