AS2005: Building a parent-child hierarchy on a table that also includes a surrogate key

Hi,

Any assistance with this will be most useful as I'm struggling to find a difinitive answer anywhere.

I have a table that includes a Surrogate Key column (primary key), a Child ID column, a Parent ID column and a Description column.

When building a parent-child dimension through the Analysis Services 2005 wizard the first decision comes on the 'Select the Main Dimension Table' screen. The Surrogate Key has to be selected as the 'Key Column' (for the relationship to the Fact Table) and the Description column is selected for the 'Column containing the member name (optional)'.

The next screen is 'Select Dimension Attributes' - do I select Child ID, Parent ID or both? And do I need to make any changes to the 'Attribute Key Column' and 'Attribute Name Column' fields in here (I cannot see why you would need to)?

Finally, the 'Define Parent-Child Relationship' screen highlights the issues around selecting the Surrogate Key as the 'Key Column' previously. Even though the DSV has the relationship between Child ID and Parent ID clearly defined, the dimension wizard attempts to build a parent-child hierarchy using the Surrogate Key and Parent ID.

I have tried building this dimension using the Child ID as the 'Key Column' instead and the structure seemed to turn out okay. However, as there is no relationship between Child ID and the Fact Table this arrangement meant that the cube process resulted in no data being displayed.

If anyone can please shed light on this frustrating issue I will be very grateful.

Thanks,

Stu

Some earlier posts in this forum have discussed similar parent-child scenarios. One solution which should work, but may increase cube processing time, is to substitute a Named Query for the fact table. This Named Query would join the fact and dimension tables on the Surrogate Key, so that the Child ID gets added as a field to the resultant fact table. Then the dimension can be built from another Named Query on the dimension table, which eliminates the Surrogate Key. The Child ID could now be the key column, which you said worked OK.|||

Thanks Deepak.

I'm aware that there are several work arounds but very surprised that this cannot just be resolved within Analysis Services (excluding the use of named queries in the DSV).

Regards,

Stuart

AS2005 without Sql Server 2005

Is it possible to install and utilize AS2005 without SS2005 anywhere in the picture?

We'd like to use our current Sql Server 2000 setup with AS2005 (preferable on the same machine).

Any insights or links are appreciated.

Thanks,
JGPAS2005 can hook back into SqlServer 2000. Not sure that I'd run Beta on production just yet, when the release comes out it would probably be doable. The over head of both SqlServer 2000 and Analysis server 2005 should be considered, but technically it should be doable.

Mark E. Johnson

ARE THERE ANY GOOD SSRS FORUMS ANYWHERE?

I use a lot of the Microsoft forums and they are all responsive and
valuable - except for this one. I never get a question answered here. I
notice about a third of the people do ever get answers.
In addition to this SSRS is a very problematic software system with lots of
quirks.
Does anyone know of any good support forums on SSRS?
Also is there any good books? (I don't like my WROX book).
Thanks,
TThis forum is good for two things. One is an answer from me because this is
where I hang out <g> but eventually I will move on too. This is also where
you get managed newsgroup support (if you have a msdn subscription). If
using that then you are guaranteed an answer in this newsgroup.
Otherwise, the best place to go are the web based forums. That is really
where the action is for RS. This newsgroup is dying.
http://forums.microsoft.com/msdn/default.aspx?forumgroupid=19&siteid=1
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
news:uSBR2H$lGHA.4808@.TK2MSFTNGP05.phx.gbl...
>I use a lot of the Microsoft forums and they are all responsive and
>valuable - except for this one. I never get a question answered here. I
>notice about a third of the people do ever get answers.
> In addition to this SSRS is a very problematic software system with lots
> of quirks.
> Does anyone know of any good support forums on SSRS?
> Also is there any good books? (I don't like my WROX book).
> Thanks,
> T
>|||Is there any "admin" person on this forum who could close this newsgroup and
redirect people to the MSDN forum as linked below?
We should have one forum where everyone goes rather than splitting the
community amongst two places.
"Bruce L-C [MVP]" wrote:
> This forum is good for two things. One is an answer from me because this is
> where I hang out <g> but eventually I will move on too. This is also where
> you get managed newsgroup support (if you have a msdn subscription). If
> using that then you are guaranteed an answer in this newsgroup.
> Otherwise, the best place to go are the web based forums. That is really
> where the action is for RS. This newsgroup is dying.
> http://forums.microsoft.com/msdn/default.aspx?forumgroupid=19&siteid=1
> http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
> news:uSBR2H$lGHA.4808@.TK2MSFTNGP05.phx.gbl...
> >I use a lot of the Microsoft forums and they are all responsive and
> >valuable - except for this one. I never get a question answered here. I
> >notice about a third of the people do ever get answers.
> >
> > In addition to this SSRS is a very problematic software system with lots
> > of quirks.
> >
> > Does anyone know of any good support forums on SSRS?
> >
> > Also is there any good books? (I don't like my WROX book).
> >
> > Thanks,
> > T
> >
>
>|||What do you mean "this is where you get managed newsgroup support (if you
have a msdn subscription)" ? I have an msdn subscription and I get many
questions answers but not all - so there must not be any "guaraantee" unless
I dont know how to enter this newsgroup from the proper channel. I would like
to know how to enter as an msdn subscriber in that case. Thanks Bruce.
"Bruce L-C [MVP]" wrote:
> This forum is good for two things. One is an answer from me because this is
> where I hang out <g> but eventually I will move on too. This is also where
> you get managed newsgroup support (if you have a msdn subscription). If
> using that then you are guaranteed an answer in this newsgroup.
> Otherwise, the best place to go are the web based forums. That is really
> where the action is for RS. This newsgroup is dying.
> http://forums.microsoft.com/msdn/default.aspx?forumgroupid=19&siteid=1
> http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
> news:uSBR2H$lGHA.4808@.TK2MSFTNGP05.phx.gbl...
> >I use a lot of the Microsoft forums and they are all responsive and
> >valuable - except for this one. I never get a question answered here. I
> >notice about a third of the people do ever get answers.
> >
> > In addition to this SSRS is a very problematic software system with lots
> > of quirks.
> >
> > Does anyone know of any good support forums on SSRS?
> >
> > Also is there any good books? (I don't like my WROX book).
> >
> > Thanks,
> > T
> >
>
>|||As far as I know, you have to use the same e-mail address on here that is
registered with your MSDN subscription
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:EE9CBA38-603C-42DA-BC48-AA0D3B59F890@.microsoft.com...
> What do you mean "this is where you get managed newsgroup support (if you
> have a msdn subscription)" ? I have an msdn subscription and I get many
> questions answers but not all - so there must not be any "guaraantee"
> unless
> I dont know how to enter this newsgroup from the proper channel. I would
> like
> to know how to enter as an msdn subscriber in that case. Thanks Bruce.
> "Bruce L-C [MVP]" wrote:
>> This forum is good for two things. One is an answer from me because this
>> is
>> where I hang out <g> but eventually I will move on too. This is also
>> where
>> you get managed newsgroup support (if you have a msdn subscription). If
>> using that then you are guaranteed an answer in this newsgroup.
>> Otherwise, the best place to go are the web based forums. That is really
>> where the action is for RS. This newsgroup is dying.
>> http://forums.microsoft.com/msdn/default.aspx?forumgroupid=19&siteid=1
>> http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
>> news:uSBR2H$lGHA.4808@.TK2MSFTNGP05.phx.gbl...
>> >I use a lot of the Microsoft forums and they are all responsive and
>> >valuable - except for this one. I never get a question answered here.
>> >I
>> >notice about a third of the people do ever get answers.
>> >
>> > In addition to this SSRS is a very problematic software system with
>> > lots
>> > of quirks.
>> >
>> > Does anyone know of any good support forums on SSRS?
>> >
>> > Also is there any good books? (I don't like my WROX book).
>> >
>> > Thanks,
>> > T
>> >
>>|||Thanks Dave - I am not sure that guarantees me a response here though ...
that was my question ... since I havent always received one. However that
isnt meant as a complaint because the people here are pretty good about
answering things they have experienced themselves.
"Dave Frommer" wrote:
> As far as I know, you have to use the same e-mail address on here that is
> registered with your MSDN subscription
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:EE9CBA38-603C-42DA-BC48-AA0D3B59F890@.microsoft.com...
> > What do you mean "this is where you get managed newsgroup support (if you
> > have a msdn subscription)" ? I have an msdn subscription and I get many
> > questions answers but not all - so there must not be any "guaraantee"
> > unless
> > I dont know how to enter this newsgroup from the proper channel. I would
> > like
> > to know how to enter as an msdn subscriber in that case. Thanks Bruce.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> This forum is good for two things. One is an answer from me because this
> >> is
> >> where I hang out <g> but eventually I will move on too. This is also
> >> where
> >> you get managed newsgroup support (if you have a msdn subscription). If
> >> using that then you are guaranteed an answer in this newsgroup.
> >>
> >> Otherwise, the best place to go are the web based forums. That is really
> >> where the action is for RS. This newsgroup is dying.
> >>
> >> http://forums.microsoft.com/msdn/default.aspx?forumgroupid=19&siteid=1
> >>
> >> http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Tina" <tinamseaburn@.nospammeexcite.com> wrote in message
> >> news:uSBR2H$lGHA.4808@.TK2MSFTNGP05.phx.gbl...
> >> >I use a lot of the Microsoft forums and they are all responsive and
> >> >valuable - except for this one. I never get a question answered here.
> >> >I
> >> >notice about a third of the people do ever get answers.
> >> >
> >> > In addition to this SSRS is a very problematic software system with
> >> > lots
> >> > of quirks.
> >> >
> >> > Does anyone know of any good support forums on SSRS?
> >> >
> >> > Also is there any good books? (I don't like my WROX book).
> >> >
> >> > Thanks,
> >> > T
> >> >
> >>
> >>
> >>
>
>|||Dave Frommer wrote:
> As far as I know, you have to use the same e-mail address on here
> that is registered with your MSDN subscription
Even if that's true (and I'll need some convincing), there's no way in hell
I'd ever post anything anywhere with my real email address. I get quite
enough spam and junk in my email as it is, without wanting to invite more
from anyone that's capable of reading email messages from Microsoft's news
servers...
--
(O)enone|||Actually here are the instructions. Also allows you to register a
"nospam" alias e-mail account.
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx

Are the chat transcipts archived anywhere ?

I know there was a technical chat today about indexes.. Are they archived
anywhere ?You can search all the messages at:
http://www.google.com/advanced_group_search?hl=en
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I know there was a technical chat today about indexes.. Are they archived
> anywhere ?
>|||I am talking about
http://communities2.microsoft.com/home/chatroom.aspx?siteid=34000015
"I_AM_DON_AND_YOU?" <user@.domain.com> wrote in message
news:eSUZfVqkDHA.1960@.TK2MSFTNGP12.phx.gbl...
> You can search all the messages at:
> http://www.google.com/advanced_group_search?hl=en
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> > I know there was a technical chat today about indexes.. Are they
archived
> > anywhere ?
> >
> >
>|||Is below what you are looking for?
http://support.microsoft.com/default.aspx?scid=fh;EN-US;pwebcst
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I know there was a technical chat today about indexes.. Are they archived
> anywhere ?
>|||Yes, at
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/support/Default.asp?fr=0&sd=tech.
--
Hope this helps,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I know there was a technical chat today about indexes.. Are they archived
> anywhere ?
>

Are nulls slow?

I have several tables anywhere from 50,000 to 100,000 rows with about 100 columns in each that allow nulls. How bad will this affect performance (if any)?

If it's significant, how can I replace nulls with zeros without doing it column by column? (100 columns will take too much time)

thanksI dont think null will affect the perfomance.Below code will generate update statement for ur tables,columns which allow null values.Run this code, copy and paste the result to query analyser and execute.

select 'update '+TABLE_NAME+' set '+COLUMN_NAME+'=0 where '+COLUMN_NAME+' is null'
from INFORMATION_SCHEMA.COLUMNS
where IS_NULLABLE='YES'