I am hoping to get some ideas for my problem. We have a handful of cubes that have cost center charged and cost center originating. Many user request to be able to just report on cross charging (originating not equal to charged). I have written a macro in the refresh event that eliminates record where the two are the same. It works very well and allows all normal BW operations to be performed. But it is not efficient from the perspective that it can only analyze the records after they have been returned (so excel limitations for number of records takes over before I can reduce the amount of records with the macro).
Does anyone have ideas on how else I could handle this? I looked at the option of creating a "cross charge" characteristic in the cubes. Just a Y/N indicator, but that poses issues I would rather not deal with.
Any suggestions would be much appreciated. I'm sure there is something obvious I am not thinking of, or am just not aware of.