Hi and thank you in advance
I two Organization Dimension: Called Actual and Company
Both have the following categories
Region
District
Territory

Note that although they look the same, One is the view from when the sales
was done (lets called ACTUAL) and the other is the company organization.
I also have to two budget type:

Territory Budget and sales Budget.
Note that the Territory Budget only contains a Territory, not th Region and
District

The Sales Budget Contains the Region and District only
Territory Budget is use when using the Company organization and Sales Budget
when using the ACTUAL.

Futhermore, I do know under what region and district a territory solditems
so that I can find the Total Sales.

My problem is as follow:
Should I create s Dimension for each Organization that will include the
territory, and then one cube for Sales and Budget and cube for Sales and Rep
Budget.
But the problem is that if I want to report as follow:
A view of the organization (rep View)
Region
District
Territory Total Sold

Company View
Region
District
Territory Total Sold Total Territory Budget

Two different view of the data.
Thank you in advance