on 01-28-2015 9:32 AM
BPC Experts,
I m trying to export transaction data from BPC from one MODEL , While exporting i wanted to ignore the records whose aggregated value is zero for the dimension member combination.
Where i can restrict or set , EXPORT only for SIGNED DATA <> 0.
Hello,
Simply create the DM package with the chain /CPMB/LIGHT_OPTIMIZE and the Dynamic script:
TASK(/CPMB/SWITCH_TO_LOAD,INFOCUBE,%APPBINAME%)
TASK(/CPMB/SWITCH_TO_PLAN,INFOCUBE,%APPBINAME%)
TASK(/CPMB/DELETE_INDEX,DTA_CUBE,%APPBINAME%)
TASK(/CPMB/CREATE_INDEX,DTA_CUBE,%APPBINAME%)
TASK(/CPMB/CREATE_STATISTICS,DTA_CUBE,%APPBINAME%)
TASK(/CPMB/LIGHT_COMPRESS,DTA_CUBE,%APPBINAME%)
TASK(/CPMB/ROLL_UP,DTA_CUBE,%APPBINAME%)
TASK(/CPMB/LIGHT_COMPRESS,ZERO_ELIMINATION_ON,X)
The last line will enforce zero elimination.
Post which, run Export Transaction data .Hope it helps
Regards
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Do optimization of f=model i.e. Run light optimise.
Or you can try SKIPIF option in transformation file.(not sure)
Shrikant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Performance point of view optimization is required. As i mentioned in previous post lite optimization Closes the open request, compresses without Zero-Elimination and indexes the cube, and updates database statistics for the BW Info-Cube.
As per my understanding there are no such prerequisite , but for safer side you can process all dimension of model.
Also go through the links that are shared. If you required more details you can search on forum. There are lot of threads on lite optimization.
Problem removing zeros in a model - BPC 10 NW
Full Optimization and Light Optimization In Detail.
I tried SKIPIF=0 and SKIPIF = NULL . Both are not working, It still downloads with zero value records when exporting transaction data. If there is any other way we can exclude using transformation or conversion file. Please provide your inputs. I m trying to explore the possibility to achieve this when using export transaction data process chain option
But lite optimization is working. i tried by clearing one record then ran lite optimization process chain from BPC.It removes the '0' records from the backend cube..
Hi,
First run lite optimization remove zeros from data and then export.
lite optimization Closes the open request, compresses without Zero-Elimination and indexes the cube, and updates database statistics for the BW InfoCube.
for lite optimization follow below links
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.