You can use DATAEXPORTCOND to specify the condition along wih DATAEXPORT to get what you need.
Look here if it helps: http://docs.oracle.com/cd/E40248_01/epm.1112/essbase_tech_ref/dataexportcond.html
Hope this helps
You want to exclude ZERO data while exporting. Ami I right?
You can use DATAEXPORTCOND to do that as i mentioned above but it has to check every combination and might be time consuming.
Note: You may have to check if you realy need ZERO data in your application.
Sorry I was thinking about missing rows when I typed and was still under the belief that I typed missing. My bad.
Well zeros, you should think about making them as missing. Usually that is what many people will do (Convert zeros to missing)
I do acknowledge your suggestion.
For the current scenario, I think, its better to make ZERO's to #Missing using a rule and do a full export, which will give all Non-Zero data.
Anyways, Zero's are creating unusual blocks, which should be Cleaned.
Using DATAEXPORTCOND is more meaningful if need to extract data which has to pass through certain complex conditions.
PS: The query was raised by Sriram.
If you are going to clear out zero data and make it #Missing (a step I recommend 99% of the time), see this thread: