cancel
Showing results for 
Search instead for 
Did you mean: 

Records coming in two lines in query.....

Former Member
0 Kudos

Hi ,

I created a query using a multiprovider.

Multiprovider contains one cube and one info object.

Cube contains the transaction data for the customer while info object contains the master data for the customer

In cube ther is an amount field.Info object contains the credit limit for the customer

i want to do exception based reporting based on amount and credit limit

But when i execute my query i am getin two lines for each customer

first line contains the data from cube and the second line contains the credit limit values from the infoobject.

i want it in one line.

Output is some thing like this:

Customer Material Date Creditlimit Amount

1 Iron 29.08.2008 1000

  1. 5000

I want the credit limit value also to come in the first line.

Regards

Ansari

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi ,

You will always get two lines with multiprovider.

This is inherent behaviour of MP.

In case you want to display Customer Master and Transaction data in one report , try using Infoset as it displays intersection not union like multiprovider.

Also, you can try for writing routines at transformation level so as to update customer information from master data directly in cube.

Hope it helps.

Rahul

former_member205352
Active Contributor
0 Kudos

Why do need the infoobject in the multiprovider ??

To access CREDIT LIMIT a key figure attribute of 0CUSTOMER.

you need to create a formula variable with replacement and choose attributes.

This formula variable can be used in key figure.

Hence you output will be in single line.

Hope this helps.

Former Member
0 Kudos

Do u mean to say use the cube for reporting not the multiprovider and create a formula variable in the query and use it..

Can you pls give me details on how to do this??

Regards

Ansari

former_member205352
Active Contributor
0 Kudos

It doesnt matter where you create the query on as long as your 0CUSTOMER is present in it.

You can create a formula variable of type replacement path and choose attribute and Credit Limit.

Hope this helps.

Former Member
0 Kudos

Praveen i am not much exp in BI.

I have a cube and an info object.

Cube contains transaction data and infoobject contains master data.

How to get both in the query at the same time.

Multiprovider giving two lines.

How to write formula using replacement path?

Regards

Ansari

former_member205352
Active Contributor
Former Member
0 Kudos

But praveen my requirement to make an exception based query.I have to compare the values coming in credit limit and and values of the amount field.Based on that i need to change the color of the colomn.

Now by using replacement path will i be able to do this comparison.

former_member205352
Active Contributor
0 Kudos

Ofcourse you can.

Now create a formula or CKF say Credit Limit and introduce the formula variable into it.

Now this behaves as keyfigure.

Amount is other key figure.

Now you can write you exception

Hope this helps.

Former Member
0 Kudos

Praveen thanks for that reply.

I have got 80% work done now.

i got the two colomns together in the output now.

how to use exceptions and compare these two fields now so that based on that i can change the color of the field..

Former Member
0 Kudos

Hi there,

That's normal with Multicubes. It does the union between two records, if you can't map some characteristics, or you have different values from both it will union both, that's why your seeing a line from the cube and a different line from the InfoObject.

If you can't map you should consider InfoSet, that will do intersection, therefore for the same customer will intersect the values.

Diogo.