Skip to Content
author's profile photo Former Member
Former Member

Detailed multiprovider

Hi gurus,

I’d like to have detailed records on a multiprovider, ‘cause I need to print detailed data.

Cube 1

Item / week / Invoice $

1425 / 2006.01 / 201

1425 / 2006.02 / 301

1425 / 2006.03 / 401

Cube 2

Item / week / Payment $

1425 / 2006.03 / 650

Multiprovider

Item / week / Invoice $ / Payment $

1425 / 2006.01 / 201

1425 / 2006.02 / 301

1425 / 2006.03 / 401 / 650

Right now what I’m having is a summarized one:

Item / week / Invoice $ / Payment $

1425 / 2006.01 / 903 / 650

I’ll appreciate your help.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 09:41 AM

    Hallo pejl,

    i think there must be a mistake in the sheet

    "Zeitmerkmale", Identifikation beteiligter Merkmale

    => 0FISCPER: Please check it.

    Santra

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Santra,

      Just to let you know that all our cubes comes from flat files, all their objects are Zs.

      Thanks for your answer.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 09:44 AM

    Hi pejl

    please do check for the identifications in the multiprovider. that should solve your problem.

    regards

    vijaykumar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi vijaykumar,

      Thanks for your answer, I made many tests handling identifications and finally it worked. I can see now the detail data.

      Now, I have another question. In Cube 1, there is another object (Sales Center) which does not have a correspondent identification in Cube 2, but I need to print it in the query. But adding this object makes the query to print the info in two rows:

      SalesC / Item / week / Invoice $ (CUBE 1)

      AA / 1425 / 2006.01 / 201

      AA / 1425 / 2006.02 / 301

      AA / 1425 / 2006.03 / 401

      SalesC / Item / week / Payment $ (CUBE 2)

      1. / 1425 / 2006.03 / 650

      Ideal result:

      SalesC / Item / week / Invoice $ / Payment $

      1425 / 2006.01 / 201 /

      1425 / 2006.02 / 301 /

      1425 / 2006.03 / 401 / 650

      Sales Center will be used for navigation and summarization purposes. Any idea how to fix this? Thanks.