How to synchronize objects

building reports desktopintelligence
1

Hi All,

  I have a report which shows count of various objects in a report.

  These objects are coming from different data providers i.e. Universes and Stored Procedure.

  Now, the problem is, report is showing proper count for the objects which are coming from Universes, but its showing wrong count for the objects that are coming from Stored Procedures.

  So, anyone has any idea how to synchronize these objects coming from different data providers i.e. Universes and Stored Procedure ?

  Thanks in advance.

schoudhary (BOB member since 2007-09-21)

2

try linking the data providers

peacock (BOB member since 2002-11-07)

3

I tried that also, but no luck.

schoudhary (BOB member since 2007-09-21)

4

how will you apply the count?

peacock (BOB member since 2002-11-07)

5

Objects coming from Stored Procedures are counted at Report Level and Objects coming from Universe are already counted at Universe Level.

The problem is when I tried to group them in a single table, it is dividing it into tables.

E.g.

Section1 : XYZ

Section2 : ABC

Total1 | Total2 | Total3 |

100   |      200   |       0    |

Section2 : ABC

Total1 | Total2 | Total3 |

0 | 0 | 300 |

As you can see, Total3 is zero in first section, and it is showing actual count as 300 in the next subsequent section.

But the expected output should be :

Section1 : XYZ

Section2 : ABC

Total1 | Total2 | Total3 |

100   |      200   |     300   |

I hope, this will explain my problem in broader sense.

schoudhary (BOB member since 2007-09-21)