Report with two hierchies

[Former Member]

I have a report with this design:

                                         CATEGORY

                                           TIME

ACCOUNT CEBE

My dimensión CEBE has one HIER with two groups. One with OFFICE (O1,O2,...On) and ZONA (Z1, Z2,...Zm)

My dimensión ACCOUNT  has two HIER. H1=OFFICE and H2=ZONA. Only one chart of accounts for the presentation of financial statements.

However the HIER are differents:

H1.OFFICE

         TRAVEL

              Internal

              External

H2:ZONA

         TRAVEL

             Internal

             Out

I input 3.000u  in Internal account+Oficce 1. n my report I select my account = H1+H2, and office1. I will need that report shows

OFFICE  3000

    Travel 3000

       Internal 3000

       External      0

ZONA            0
      Travel      0

         Internal 0

          Out      0

Bu my report show in H2

ZONA       3000

    Travel    3000

     Internal 3000

      Out            0

Why? The result of my office1  must only in OFFICE. Could anyboy give me a hint in that matter?

Thanks

RTS

[former_member186338]

Something is wrong with your explanation...

You can't have same parent with different children in different hierarchies!

Please provide real screenshots.

Vadim

[Former Member]

Hi Vadim

Attach screenshoot, is real!!

Regards

RTS

[former_member186338]

Sorry, but you have 2 different nodes with identical descriptions... Do you understand what I mean?

And if you want to show hierarchy - please show the screenshot of the dimension administration, not report!

Vadim