Is it possible to certain columns from different dimensions and certain measures from the fact to prepare a report from a cube instead of dragging the whole cube...
Its like preparing a cube and then generating different reports from that cube by using different cols
I'm not certain I'm understanding. If you're talking about creating a crosstab with only some of the dimensions and measures from a cube, rather than dragging the cube into your design, you can pull a crosstab from the palette and drag just the dimensions and measures you want to use into it. Let me know if I'm mistaken on what you're asking.
Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.