I create a query,the query has 3 columns,
Fields Name: Col_A, Col_B, Col_C
Fields Value: 1001.....001 ... X
I want to connect the Col_B and Col_C, so I add a column Col_D, like this:
Fields Name: Col_A, Col_B, Col_C, Col_D
Fields Value: 1001 ... 001 .. ..X .... ..001X
and then I hidden Col_B and Col_C in the excel. save the query as a workbook.
When I open the workbook,and refresh it,the hidden Col_B and Col_C were appear.
PLZ tell me how to hide the columns Col_B and Col_C, If I refresh the workbook,they will be hidden either.
My BEX Analyzer version is BI AddOn 7.x(based on 7.10), Support package 8, Revison 1408.
Edited by: Bruce Wang on Jul 26, 2010 11:28 AM
Edited by: Bruce Wang on Jul 26, 2010 11:29 AM