Showing posts with label structure. Show all posts
Showing posts with label structure. Show all posts

Thursday, March 29, 2012

Description for Calculated Members

You can add descriptions to measures that are built under the Cube Structure tab. But I cannot see how to add a description to a Calculated Member. Is it possible to add a description to a Calculated Member?
Looks like this has already been answered.

Anyone interested, here is the link.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=325816&SiteID=1
|||You might be interested in looking at BIDSHelper www.codeplex.com/bidshelper it's free addin for BI Development Studio that adds a number of useful features including the ability to add descriptions to calculated members (through the member properties dialog) http://www.codeplex.com/bidshelper/Wiki/View.aspx?title=Calculation%20Helpers&referringTitle=Home

Describing a table structure

Hi Jig,
I too had the same problem, coming from an Oracle
background. The SQL Server equivalent of 'desc' is
sp_help, followed by the table name in single quotes.
e.g. To descibe the table employees in the Northwind
database:
Use Northwind
sp_help 'employees'
This give the same info as the Oracle 'desc'
Mark

>--Original Message--
>Hi,
>I would like to know the syntax in MS SQL 2K for
describing a table, without
>having to expand everything in the object browser.
>I know in Oracle it is: desc <table_name>;
>Thanks,
>Jig.
>.
>
Thanks.
"Mark Laffey" wrote:

> Hi Jig,
> I too had the same problem, coming from an Oracle
> background. The SQL Server equivalent of 'desc' is
> sp_help, followed by the table name in single quotes.
> e.g. To descibe the table employees in the Northwind
> database:
> Use Northwind
> sp_help 'employees'
> This give the same info as the Oracle 'desc'
> Mark
> describing a table, without
>

Describing a table structure

Hi,
I would like to know the syntax in MS SQL 2K for describing a table, without
having to expand everything in the object browser.
I know in Oracle it is: desc <table_name>;
Thanks,
Jig.
Do you mean
sp_help tblname
"Jig Bhakta" wrote:

> Hi,
> I would like to know the syntax in MS SQL 2K for describing a table, without
> having to expand everything in the object browser.
> I know in Oracle it is: desc <table_name>;
> Thanks,
> Jig.
|||is that the only way?
"Nigel Rivett" wrote:
[vbcol=seagreen]
> Do you mean
> sp_help tblname
> "Jig Bhakta" wrote:
|||This will create a script for it
http://www.mindsdoor.net/DMO/DMOScripting.html
and this will do a database or all databases on a server
http://www.mindsdoor.net/DMO/DMOScriptAllDatabases.html
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi,
there may be other ways, but this gives the info in more
or less the same format as you get in Oracle. Just make
sure that you select 'Results in grid' from the Query tab.
Jig,
that is the correct format
Mark
[vbcol=seagreen]
>--Original Message--
>is that the only way?
>"Nigel Rivett" wrote:
describing a table, without
>.
>