How to share dimensions for multiple cubes in AS 2005?

Hello,

I have a couple of cubes that I created using a wizard in AS 2005. Every time I create a new cube, a AS wizard adds dimensions with 1,2 etc at the end of their names. Is it possible to use/share existing dimensions which are used by other cubes instead of having bunch of dimensions which are the same and the only difference is their name?

Thanks!

When you are going through cube building wizard, once you get to the Review Shared Dimensions page, select all the dimensions that you want to reuse. The wizard will reuse these dimensions and it won't create the dimensions with the 1,2 etc.

Hope this helps.

Van Dieu

|||Altering what you have already generated may be complicated. I don't use the wizard to generate cubes, so I'm not sure how much work is involved to change it. It might be as simple as opening the cube editor, deleting the dimensions that are duplicates, and adding the ones that you want to use, but I doubt it. You'll probably have to alter the data source view and the dimension usage in the cube editor as well.|||

Actually, it is that easy. You can just open up the cube editor and delete all the duplicated dimensions. Then on the dimension usage tab add them back in (the dimensions that you want to share).

Van Dieu

|||Good to know

How to set up a SQL Server for storing Chinese characters

Any idea what is the set up process is? I've tried a couple of
different character set and it's still not displaying the characters
correctly. I could insert the Chinese characters into a table using
INSERT with no error, but the SELECT statement shows "?"
Thanks for any help in advance.
John
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
John,
Are you using the Unicode datatypes of Nchar, Nvarchar, Ntext to store your
Chinese characters?
Also, you might want to read the MSDN article "International Features in
Microsoft SQL Server 2000" at:
http://msdn.microsoft.com/library/de...Server2000.htm
as it has a lot of info on how to setup and use Chinese characters.
Regards,
John
"John Lee" <john.lee104@.verizon.net> wrote in message
news:#JAsC#3HEHA.3356@.TK2MSFTNGP11.phx.gbl...
> Any idea what is the set up process is? I've tried a couple of
> different character set and it's still not displaying the characters
> correctly. I could insert the Chinese characters into a table using
> INSERT with no error, but the SELECT statement shows "?"
> Thanks for any help in advance.
> John
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Now I'm all set with saving and displaying the data. My next question
is how to script that for setting up a MSDE SQL server.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||If you have access to SQL Server 2000 Standard or Developer Editions (or
above), you can use the Enterprise Manager to "generate SQL scripts" for
your database. If you don't have access to these Editions, there are several
"free" or low-cost "Enterprise Manager-like" tools, such as the following:
TOAD for SQL Server at http://www.toadsoft.com/toadss.html
and Microsoft's new SQL Server Web Data Administrator at:
http://www.microsoft.com/downloads/d...displaylang=en
Regards,
John
"John Lee" <john.lee104@.verizon.net> wrote in message
news:uMLEEBBIEHA.2836@.TK2MSFTNGP11.phx.gbl...
> Now I'm all set with saving and displaying the data. My next question
> is how to script that for setting up a MSDE SQL server.
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

How to set -g startup option? is it permanent?

Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003
Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.c om...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003
|||Thanks! .. I have been racking my brain trying to figure that out.
Hopefully this will solve our problem.
Kyle
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

How to set -g startup option? is it permanent?

Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.com...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003|||Thanks! .. I have been racking my brain trying to figure that out.
Hopefully this will solve our problem.
Kyle
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

How to set -g startup option? is it permanent?

Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
times a day error: failed to reserve continidous memory of size=6xxxx
We have reseached and found that setting the -g startup option may
solve this problem, but I have no clue how to set it. I have looked
on books online too as suggested with no help.
Is there a permanent way to set this option? We are pretty close to
reformatting and reinstalling at this point.
Thanks in advance.
Kyle
SETUP:
DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
MS Small Business Server 2003
MS SQL Server 2000 w/ Service Pack 3
Icode Everest Enterprise (ERP)
MS Exchange 2003Hi Kyle
This is a startup flag for the sqlservr.exe executable. You can go to
Enterprise Manager and choose the startup parameters button on the General
tab. Add -gNNN as a parameter. Start and restart your SQL Server. You can
read a bit more about this in the Books Online under "Command Prompt
Utilities" (you can also start SQL Server from a command prompt), but you're
not, it's never really clear HOW to set this parameter.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Kyle West" <kyle@.wiredspeed.com> wrote in message
news:64202bb4.0407221800.43f847fd@.posting.google.com...
> Couple weeks ago we started have SQL issues. SQL Server crashes 2-3
> times a day error: failed to reserve continidous memory of size=6xxxx
> We have reseached and found that setting the -g startup option may
> solve this problem, but I have no clue how to set it. I have looked
> on books online too as suggested with no help.
> Is there a permanent way to set this option? We are pretty close to
> reformatting and reinstalling at this point.
> Thanks in advance.
> Kyle
> SETUP:
> DELL PowerEdge 2650 2x 2.8GHz XEON - 4GB RAM - 4x 15k RAID
> MS Small Business Server 2003
> MS SQL Server 2000 w/ Service Pack 3
> Icode Everest Enterprise (ERP)
> MS Exchange 2003