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...
Thanks Nagraj.
I dont know the time this report will take as I have been working with the sample data set only. But the actual data would be over a million records and potential of growing exponentially with time. Thats the reason for concern.Maybe view would be a better option.
Regards
Thanks Lex. My apologies for presenting incomplete problem in a rush to get a solution.
Here are the details:
For a single F1, there can be multiple occurences of F2 and likewise multiple F3 for a single F2. F4 is actually an attribute of F3(values with varying level of severity not just 'High'...
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...
Thanks Flex13 for understanding my problem even though I could not put it clearly in my question.
I have a general idea of creating a separate Time table and linking it to source data. But I would like to hear about your version of 'How?'.
Another request: is there any books/white...
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...
Thank you guys for your input.
Correct me if I am wrong but I think the solution mentioned above will work( without the need of category count) if the data source is specifically customer file. But things are different if the data source(IQD) is in the form of fact table. The col_count(field...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.