Search results for query: *

Hi All, I have seen very helpful hints to convert columns to multiple rows in a report. I am trying to do the converse: F1 F2 F3 F4 *************************** A 1 a a1 A 1 b b1 : : : : : : : : A 1 c c1 A 2 a a1 A 2 b b1 F1 F2 F3-1 F4-1 F3-2 F4-2 .......F3-n F4-n...

Hi All, I need to build a field in impromptu report as follows: F1 F2 F3 F4 Reflected F4 ________________________________________ a1 r1 b1 low low a1 r1 b2 lOW low a1 r2 b1 low high a1 r2 b2 high high a1 r2 b3 low high a2 R1 b1 high high a2 r2 b2 null high *********** The problem is how...

Hi All, I am creating a cube with two category count measures based on ordid and itemid. Data source is a single .iqd file: #Orders #Items Here are two sample reports: Measure Selected : #Items TYPE1 TYPE2 ITEM_TYPE 2000 4 4 8 2001 2 3...

Hello All, I would appreciate your help on handling Time Dimension for a given scenario. The analysis for a particular report is done on Day/Hour/15 minute segment basis. The incoming field is a Date column in oracle(of course we will bring this into IQD first). How should the time dimension be...

Hello Everyone, I need a measures to give distinct counts over various dimensions. The column(lets call it col_id) on which the counts are based on is not required as a dimension/level. But I embed it as a level only for using category counts and later suppress that complete category. Also...