creating replication with extra column

Hi ,
I have a few tables that i wanted to replicate from ServerA to ServerB ,
however, these tables in ServerB needs a country code column as it's sort of
a Data Center.
How i can add the column during replication setup ?
kindly advise
tks & rdgs
Use the ALTER TABLE statement to add the column to the subscription table.
Note the column must allow NULLs or have a DEFAULT constraint.
HTH
Jerry
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:3329F606-26D6-4D88-8E45-D623C8787E49@.microsoft.com...
> Hi ,
> I have a few tables that i wanted to replicate from ServerA to ServerB ,
> however, these tables in ServerB needs a country code column as it's sort
> of
> a Data Center.
> How i can add the column during replication setup ?
> kindly advise
> tks & rdgs

creating replication with extra column

Hi ,
I have a few tables that i wanted to replicate from ServerA to ServerB ,
however, these tables in ServerB needs a country code column as it's sort of
a Data Center.
How i can add the column during replication setup ?
kindly advise
tks & rdgsUse the ALTER TABLE statement to add the column to the subscription table.
Note the column must allow NULLs or have a DEFAULT constraint.
HTH
Jerry
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:3329F606-26D6-4D88-8E45-D623C8787E49@.microsoft.com...
> Hi ,
> I have a few tables that i wanted to replicate from ServerA to ServerB ,
> however, these tables in ServerB needs a country code column as it's sort
> of
> a Data Center.
> How i can add the column during replication setup ?
> kindly advise
> tks & rdgs

Creating Dimensions

I have a cube with a dimension 'Destination', that has the follown herarchy.

Country -> State -> City.

As measure I have Number of transactions.

When I browse the cube I can get the total transactions if I expand all the levels, but If I just want o have number of transactions by state or country the cube is no creating totals by those levels. Even in the cube when I expand all levels (including city), there are not totals by state and country. What I am missing?

You can email me to jzuluaga@.msn.com or jzuluaga@.quisqueyana.com

Thanks

Juan,

What are you using to browse the cube?

Steve

|||

Check the calculations of the cube and make sure that it contains the CALCULATE command. This command is always included by default, but if it is deleted accidentally, then you will only get leaf level data as this command is what instructs the server to aggregate data up from the lowest levels up to the higher levels.