Multiple rows in Report

[Former Member]

Hi All,

I have created Multiprovider on top of 2 DSO,s , but I am getting Multiple rows in Reports , I have Looked at couple of documents and  tried with Constant selection ,but no Luck.

Hope, I can do Lookup  while loading data in to DSO1,but because of  value of data , I prefer to go Multi provider .

Is there any approach to avoid multiple rows in report ?

Regards

Hari

[ccc_ccc · Accepted solution]

Hi Hari,

Multiple Rows:

1. What are COMMON objects available in two DSO's
2. Did you assigned properly
3. Did you used/drill down same objects in ROWS at BEx
4. Please share current output and expected output.

Thank you,

Nanda

[Former Member · Accepted solution]

Hi nanda,

Thanks for your prompt reply.

These are fields are common in bothDSO, but I am only using First 3 Objects .

I do not used /drill down in Rows at BEx

DSO1	DSO2
EMPLOYEE	EMPLOYEE
DATETO	DATETO
/BIC/ZSTDT	/BIC/ZSTDT
EMPLGROUP	EMPLGROUP
EMPLSGROUP	EMPLSGROUP
ORGUNIT	ORGUNIT
HRPOSITION	HRPOSITION

Regards

Hari

[ccc_ccc · Accepted solution]

Hi Hari,

The data which your displaying may be different .

please paste output here.

Thank you,

Nanda

[Former Member · Accepted solution]

Hi nanda,

I am getting out put like this at the moment , i like to display in a single line.

Table

Employee

Title

Name

Name 2

Gender

ID Number

Date of Birth

Address Type

Street and House Num

2nd Address Line

Postal Code

Country

Number of Records

Cap Utilization Leve

Basic salary

Annual Amount

88888888

88888888

#

James

Web

Male

#/SC123456A

27-08-1983

Permanent residence

100 Cranston Close

Not assigned

TW7 2AA

GB

United Kingdom

1

#

#

unknown

#/#

#

Not assigned

Not assigned

Not assigned

Not assigned

#

Not assigned

2

0.00

0

0

[Former Member · Accepted solution]

Hi Nandu,

Cap utilization and basic salary coming from DSO2 and rest of the fields mostly coming from DSO1.

Basically I want to get the data from PA0002( employee details)  ,PA0006( address)  and PA0008( basic salary).

DataSource from PA0002 and PA0006 in DSO1 and Other DataSource from PA0008 into DSO2 , to combine these two DSos , I am trying to create MultiPorvider.

Regards

Hari

[ccc_ccc · Accepted solution]

Hi Hari,

Display only below objects and check output.

EMPLOYEE	EMPLOYEE
DATETO	DATETO
/BIC/ZSTDT	/BIC/ZSTDT
EMPLGROUP	EMPLGROUP
EMPLSGROUP	EMPLSGROUP
ORGUNIT	ORGUNIT
HRPOSITION	HRPOSITION

Thank you,

Nanda

[ccc_ccc · Accepted solution]

Hi Hari,

Display only below objects and check output.

EMPLOYEE	EMPLOYEE
DATETO	DATETO
/BIC/ZSTDT	/BIC/ZSTDT
EMPLGROUP	EMPLGROUP
EMPLSGROUP	EMPLSGROUP
ORGUNIT	ORGUNIT
HRPOSITION	HRPOSITION

Thank you,

Nanda

[Former Member · Accepted solution]

Hi Nandu,

First 3 Rows I am using in both DSOs,

Employee		Valid To	Start data from ANSA	Number of Records
88888888	88888888	31-07-2014	#	1
		31-12-9999	23-06-2014	1
			#	1

I am getting display like this .

Regards

Hari

[ccc_ccc · Accepted solution]

Hi Hari,

It seems like there is no data in one DSO, to find it place  "Infoprovider" infoojbect in ROWS.

Thank you,

Nanda

[Former Member · Accepted solution]

Hi Nandu,

DSO1

0DATETO	0EMPLOYEE	ZSTDT
31.12.9999	88888888	23.06.2014

DSO2

0DATETO	0EMPLOYEE	ZSTDT
31.07.2014	88888888
31.12.9999	88888888

Thanks

Hari

[ccc_ccc · Accepted solution]

Hi Hari,

In DSO2, there is no data for ZSTDT hence data displaying like that. you have to maintain DSO 2 also

Then you can see in single line

Thank you,

Nanda

[Former Member · Accepted solution]

Hi Nanda,

Thanks for your help.

I will assign points and close this thread.

Thanks

hari