i have the following n-no.of elements in my dimension so i what it omit the whichever element having "CO" and
other elements alone i want it for that i am using following condition
even though its not coming without "CO" elemenets .can someone help please?
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.CP-305.CB-285
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.CP-305.CB-285.CO-01
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.CP-305.CB-285
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.CP-305.CB-285.CO-01
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.CP-305.CB-285.CO-01
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.PC-305.CN-286
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.NC-305.CN-282
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.CP-305.CB-285.CO-01
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.CP-305.CN-289
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.PC-305.CF-285
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.CP-305.CT-288
ZC0000043.ZP002-01.ZN01-01.ZL018-01.ZI0628_00-02.CP-305.CB-285.CO-01
eles=DIMSIZ('ZC0000043');
k=1;
while(k<=eles);
elementname=DIMNM('ZC0000043',k);
length=LONG(elementname);
j=1;
while(j<=length);
id=SUBST(elementname,length1-j,j);
IF((SUBST(id,1,2) )@<>'CO') );
asciioutput('text.txt',elementname);
endif;
j=j+1;
end;
k=k+1;
end;
TI output having the problem
-
- Regular Participant
- Posts: 155
- Joined: Fri May 20, 2011 8:17 am
- OLAP Product: Applix,Cognos TM!
- Version: applix9.0Cognos tm1 9.5.1
- Excel Version: Excel 2010 2007
- Martin Ryan
- Site Admin
- Posts: 2003
- Joined: Sat May 10, 2008 9:08 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Wellington, New Zealand
- Contact:
Re: TI output having the problem
Sorry, I can't follow exactly what you're asking, but I think the solution to your problem is the "scan" function.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Jodi Ryan Family Lawyer