Handeling Parent-Child hierarchy in RS2005

hello,

I have a problem in RS2005:

In my report I see all levels in one column. However they are shown in a way that I think that if I only could get it to toggle correctly it will work out fine...

I would like my P/C dimensionto display just as it does when I use AS. Expanding top level (by pressing +), viewing next level down where I can "open" (by pressing +) next level and so on. Does anyone know how this is done or suggestions on how to solve it?

This is the kind of display I would like:

-A 100

-B 50
D 25
E 25

+C 50

Sincerely,

Hello Hanna

After you select the fields in the query builder, you are prompted to select a matrix or a tabular approach. Then, when you select matrix, you are prompted to select the fields that go to the columns, the fields that go to the rows, and so on.

All you have to do is to check the little checkbox in the lower left corner that says "Enable Drilldown". This will put all your top level member of the hierarchy in the first column and will enable you to drill down.

Did it work?

Andr

|||

Hello again...

Can you tell me what you did to be able to see all levels in one column?

I have an hierarchy:

region -> area -> district -> country

Example:

Europe (region)
Southern Europe (Area)
Southern West Europe (district)
Portugal (country)

my objective is to have the following display:

Hierarchy Value
-
Europe 1000
Southern Europe 500
Southern West Europe 250
Portugal 150
Spain 100

How can I achieve this?

I don't want the hierarchy to be displayed in more than one column like this:

Region Area District Country Value
Europe S. Europe S. West Europe Portugal 150
Europe S. Europe S. West Europe Spain 100

And I don't want the hierarchy to be displayed with drilldown like this:

Hierarchy Value
- Europe 1000
- Southern Europe 500
-Southern West Europe 250
Portugal 150
Spain 100

I just want the hierarchy to be displayed in a single column.

Andr

|||Hello Hannah,

I recently ran into the same problem. Did you solve yours?
Hopefully you can help me ...
Sincerely,
Rhapsy
|||Hello,

I found the other post "Creating report based on parent-child dimension" which includes an answer to my problem ... :D
thanks
Rhapsy

Handeling Parent-Child hierarchy in RS2005

hello,

I have a problem in RS2005:

In my report I see all levels in one column. However they are shown in a way that I think that if I only could get it to toggle correctly it will work out fine...

I would like my P/C dimensionto display just as it does when I use AS. Expanding top level (by pressing +), viewing next level down where I can "open" (by pressing +) next level and so on. Does anyone know how this is done or suggestions on how to solve it?

This is the kind of display I would like:

-A 100

-B 50
D 25
E 25

+C 50

Sincerely,

Hello Hanna

After you select the fields in the query builder, you are prompted to select a matrix or a tabular approach. Then, when you select matrix, you are prompted to select the fields that go to the columns, the fields that go to the rows, and so on.

All you have to do is to check the little checkbox in the lower left corner that says "Enable Drilldown". This will put all your top level member of the hierarchy in the first column and will enable you to drill down.

Did it work?

Andr

|||

Hello again...

Can you tell me what you did to be able to see all levels in one column?

I have an hierarchy:

region -> area -> district -> country

Example:

Europe (region)
Southern Europe (Area)
Southern West Europe (district)
Portugal (country)

my objective is to have the following display:

Hierarchy Value
-
Europe 1000
Southern Europe 500
Southern West Europe 250
Portugal 150
Spain 100

How can I achieve this?

I don't want the hierarchy to be displayed in more than one column like this:

Region Area District Country Value
Europe S. Europe S. West Europe Portugal 150
Europe S. Europe S. West Europe Spain 100

And I don't want the hierarchy to be displayed with drilldown like this:

Hierarchy Value
- Europe 1000
- Southern Europe 500
-Southern West Europe 250
Portugal 150
Spain 100

I just want the hierarchy to be displayed in a single column.

Andr

|||Hello Hannah,

I recently ran into the same problem. Did you solve yours?
Hopefully you can help me ...
Sincerely,
Rhapsy
|||Hello,

I found the other post "Creating report based on parent-child dimension" which includes an answer to my problem ... :D
thanks
Rhapsy

Handeling Parent-Child hierarchy in RS2005

hello,

I have a problem in RS2005:

In my report I see all levels in one column. However they are shown in a way that I think that if I only could get it to toggle correctly it will work out fine...

I would like my P/C dimensionto display just as it does when I use AS. Expanding top level (by pressing +), viewing next level down where I can "open" (by pressing +) next level and so on. Does anyone know how this is done or suggestions on how to solve it?

This is the kind of display I would like:

-A 100

-B 50
D 25
E 25

+C 50

Sincerely,

Hello Hanna

After you select the fields in the query builder, you are prompted to select a matrix or a tabular approach. Then, when you select matrix, you are prompted to select the fields that go to the columns, the fields that go to the rows, and so on.

All you have to do is to check the little checkbox in the lower left corner that says "Enable Drilldown". This will put all your top level member of the hierarchy in the first column and will enable you to drill down.

Did it work?

Andr

|||

Hello again...

Can you tell me what you did to be able to see all levels in one column?

I have an hierarchy:

region -> area -> district -> country

Example:

Europe (region)
Southern Europe (Area)
Southern West Europe (district)
Portugal (country)

my objective is to have the following display:

Hierarchy Value
-
Europe 1000
Southern Europe 500
Southern West Europe 250
Portugal 150
Spain 100

How can I achieve this?

I don't want the hierarchy to be displayed in more than one column like this:

Region Area District Country Value
Europe S. Europe S. West Europe Portugal 150
Europe S. Europe S. West Europe Spain 100

And I don't want the hierarchy to be displayed with drilldown like this:

Hierarchy Value
- Europe 1000
- Southern Europe 500
-Southern West Europe 250
Portugal 150
Spain 100

I just want the hierarchy to be displayed in a single column.

Andr

|||Hello Hannah,

I recently ran into the same problem. Did you solve yours?
Hopefully you can help me ...
Sincerely,
Rhapsy
|||Hello,

I found the other post "Creating report based on parent-child dimension" which includes an answer to my problem ... :D
thanks
Rhapsy

Hacking the sa password

Hi,
I was shown recently at a training session an article that showed how
your could break the sa password by using network monitoring tools and some
other steps. I am currently trying to find this myself so I can show the
developers at my company one of the reasons I am opposed to the sa account
being used and SQL logins in general.
Does anyone out there know where this article would be or what the exact
process is so I can replicate it quickly.
Cheers,
JohnWhen one uses a relatively anonymous moniker, John,
<John@.discussions.microsoft.com>", how would we know that you aren't just
trying to hack into someone's database and you are trying to get us to help
you?
;-)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"John" <John@.discussions.microsoft.com> wrote in message
news:9DB6A662-08C1-41FB-81A8-18BC7D4FCBF1@.microsoft.com...
> Hi,
> I was shown recently at a training session an article that showed how
> your could break the sa password by using network monitoring tools and
> some
> other steps. I am currently trying to find this myself so I can show the
> developers at my company one of the reasons I am opposed to the sa account
> being used and SQL logins in general.
> Does anyone out there know where this article would be or what the exact
> process is so I can replicate it quickly.
> Cheers,
> John|||Well Arnie, how do we know who anyone really is over the internet. Besides
John is my name but I don't want the entire world to have all my details
especially anyone trawling through forums for personal details to SPAM or
send marketing material through too. I can also not be bothered setting up
a
hotmail bogus account as this wa y I still get emails when my posts are
replied to sent to my work email.
On a more interesting note, do you happen to know the location of the
article I am interested in. From memory it uses SQLPing2 which I already
have downloaded.
"Arnie Rowland" wrote:

> When one uses a relatively anonymous moniker, John,
> <John@.discussions.microsoft.com>", how would we know that you aren't just
> trying to hack into someone's database and you are trying to get us to hel
p
> you?
> ;-)
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:9DB6A662-08C1-41FB-81A8-18BC7D4FCBF1@.microsoft.com...
>
>|||It sounds like this may be the article you are referring to:
http://searchsqlserver.techtarget.c...00.h
tml
-Sue
On Mon, 25 Sep 2006 19:36:02 -0700, John
<John@.discussions.microsoft.com> wrote:

>Hi,
> I was shown recently at a training session an article that showed how
>your could break the sa password by using network monitoring tools and some
>other steps. I am currently trying to find this myself so I can show the
>developers at my company one of the reasons I am opposed to the sa account
>being used and SQL logins in general.
>Does anyone out there know where this article would be or what the exact
>process is so I can replicate it quickly.
>Cheers,
>John|||I have an example of a TSQL function that will do the job as part of the
following presentation
http://www.sqldbatips.com/presentat...HACKING_SQL.zip
Note that SQL2005 doesn't use the same method, it uses a self signed
certificate to properly encrypt the login handshake as opposed to SQL2000
which basically just uses obsfucation.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"John" <John@.discussions.microsoft.com> wrote in message
news:9DB6A662-08C1-41FB-81A8-18BC7D4FCBF1@.microsoft.com...
> Hi,
> I was shown recently at a training session an article that showed how
> your could break the sa password by using network monitoring tools and
> some
> other steps. I am currently trying to find this myself so I can show the
> developers at my company one of the reasons I am opposed to the sa account
> being used and SQL logins in general.
> Does anyone out there know where this article would be or what the exact
> process is so I can replicate it quickly.
> Cheers,
> John