Reporting problem

[Former Member]

Hi,

I have a reporting requirement by using an ODS which has 4 fields. all are of characteristic info objects.

Out of those four 3 fields are given as key fields and one is as data field.

Object name

class name

characteristic name

characteristic value

One object name and class name combination can have multiple characteristic names and each characteristic name will have one value.

The reporting should be as below.

objectname classname characteristicname1 charstic2 charstic3 etc

Obj1 class1 XXX abc 123

obj2 class2 yyy def 456

Please let me know how to do it?

Edited by: raj_kishore93 on Apr 6, 2009 3:19 PM

[Former Member]

HI Raj,

I think the solutions given are correct i will just try to explain it to you again. You will be putting Object Number and Class Name in Rows. This will give you records like follows

Obj1 class1

Obj2 class2

and you will add Char Name in column and below it you will add char Value which is a Key fig.

so records will look like shown below:

Char1 Char 2

Obj1 Class1 10 2

Obj2 Class2 5 1.

Just try doing this and see the results.

Thanks & Regards,

Nayan Joshi

[Former Member]

Nayan,

Characteristic value is not key figure. it is also characterstic object only. it can have non numeric values hence cannot be created as key figure.

[virenp_devi]

Hi Raj,

Create new query on the top of the DSO in Query designer. Keep Object name, class name, characteristic name in the ROWS and keep characteristic value in the columns.

This should solve your problem. let me know in case you have any doubts.

Regards,

Viren

[Former Member]

Hi raj, If i am not wrong then you are new to BI. So welcome to BI.

By the way For your requirement,

just make one query in which put Object name, class name in Row

and put characteristic name in Column.

this will give your desired output.

Regards,

[Former Member]

Hi,

I think the requirement is not understood properly.. i will elaborate it a bit.

The content in the ODS is as below.

Object Number Class name Characterstic Name Characterstic Value

Obj1 Class1 char1 val1

Obj1 Class1 char2 val2

Obj1 Class1 char3 val3

the report should be as below.

Object Number classs Name Char1 Char2 Char3

Obj1 class1 val1 val2 val3

Values of the characteristic name should be appeared as column names and respective characteristic values should come under each characteristic name..

Hope the question is clear now. Please provide me the solution..

[gaurav_kothari]

Hi Raj,

You need to include Object Number and classs Name in the Rows and Char1 in the coulumn along with the char value field.

Your out put will then look something like below.

-

---

Char1 char2

-

---

val1 val2

a-Object Number------- a-classs Name

b-Object Number-------a-classs Name

Is this what you are looking for.

Hope it helps.

Regards,

Gaurav

Edited by: Gaurav Kothari on Apr 7, 2009 11:43 AM

Edited by: Gaurav Kothari on Apr 7, 2009 11:47 AM

[Former Member]

Hi,

I already tried this but did not work...All the four fileds are characteristic info objects.

Edited by: raj_kishore93 on Apr 7, 2009 4:31 PM