Geographical realignment dimension

I have a fact table filled with clients including their address information as well as their original geographical alignment info (RegionID, DistrictID and TerritoryID). In order to forecast as well as perform an “as if” analysis, I need to be able to realign the accounts based on previous or future alignments. I have an alignment table (dimension) that maintains alignment information by year and quarter and I can join to this table using the ClientAddressID field as well as the Year and Quarter fields. I’d like to be able to make the Year and Quarter fields/join be variable so that I can perform realignments simply by changing the year/quarter.

Is this possible in SSAS or am I going to have to find another solution? Any help will be greatly appreciated...

David

I resolved this using a many to many relationship. This write-up was very useful: http://msdn2.microsoft.com/en-us/library/ms170463.aspx

David

Geographical realignment dimension

I have a fact table filled with clients including their address information as well as their original geographical alignment info (RegionID, DistrictID and TerritoryID). In order to forecast as well as perform an “as if” analysis, I need to be able to realign the accounts based on previous or future alignments. I have an alignment table (dimension) that maintains alignment information by year and quarter and I can join to this table using the ClientAddressID field as well as the Year and Quarter fields. I’d like to be able to make the Year and Quarter fields/join be variable so that I can perform realignments simply by changing the year/quarter.

Is this possible in SSAS or am I going to have to find another solution? Any help will be greatly appreciated...

David

I resolved this using a many to many relationship. This write-up was very useful: http://msdn2.microsoft.com/en-us/library/ms170463.aspx

David

sql

Generating CREATE scripts for Oracle

Hello all,
My supervisor asked me to generate create scripts of one of our clients DB
objects. Apparently they use Oracle, so I need the scripts that SQL Server
2005 creates to be compatible with the SQL that Oracle uses. I know
absolutely nothing about Oracle-have no experience with it.
I went through the Generate SQL Server Scripts Wizard to create the scripts.
Scripts were created for 3 user-defined functions, 13 tables, and 20 views.
One thing that jumps to mind is SQL Server defaults to square brackets ([])
around object names. Will Oracle recognize square brackets? I think I read
somewhere once that some DB systems don't like square brackets, and quotes
("") should be used instead of square brackets. Is this something I need to
be concerned with?
Is there anything else that anyone can think of that I need to be concerned
with?
Thanks for any help anyone can provide,
Conan KellyOn Sep 14, 12:43 pm, "Conan Kelly"
<CTBarbarinNOS...@.msnNOSPAM.comNOSPAM> wrote:
> Hello all,
> My supervisor asked me to generate create scripts of one of our clients DB
> objects. Apparently they use Oracle, so I need the scripts that SQL Server
> 2005 creates to be compatible with the SQL that Oracle uses. I know
> absolutely nothing about Oracle-have no experience with it.
> I went through the Generate SQL Server Scripts Wizard to create the scripts.
> Scripts were created for 3 user-defined functions, 13 tables, and 20 views.
> One thing that jumps to mind is SQL Server defaults to square brackets ([])
> around object names. Will Oracle recognize square brackets? I think I read
> somewhere once that some DB systems don't like square brackets, and quotes
> ("") should be used instead of square brackets. Is this something I need to
> be concerned with?
> Is there anything else that anyone can think of that I need to be concerned
> with?
> Thanks for any help anyone can provide,
> Conan Kelly
I'd rather use Oracle Migration Workbench