Dispalying AS2005 Parent-child hierarchy with RS2005

Hello,

in AdventureWorksDW at Dimemployee there is a parent-child dimension.

If I use the browse Tab in VS, I can browse all the levels of that hierarchy.

My question is How do I produce this kind of report with RS2005 sp1?

I need the report to behave the same as the browser of VS, meaning that the level depth can change.

I looked all over the web, but didn't find any solution.

Thanks,

Yoav.

Your problem is to fetch all data of parent-child dimension in a single query oi order to fit it in sinlgle SSRS report. I suppose that such solution won't satisfy you. You schould develop report getting data from SSAS by demand, not all-in-one query.|||I had the same problem. From I've been reading Reporting Services has limited functionality when dealing with Analysis Services including the parent-child relationship.

In analysis services I never designated a parent-child relationship, I just simply put the appropriate keys into the cube. That way Reporting Services can do the hierarchy just like it does for aregular SQL query.

The query should return an ID and a Parent ID. In RS create a table with just the Details row (just now at least). In the properties put the group on being the ID and the Parent being the parent ID.

For more info checkout:
http://www.codeguru.com/csharp/.net/net_data/sortinganditerating/article.php/c12223/|||

If this not is working with a SSAS2005 cube you can query the data mart/source system with a TSQL CTE(Common Table Expression). I know that this is an OLAP forum but if nothing else works try the examples i SSRAS2005 that you find on this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql_05TSQLEnhance.asp

HTH

Thomas Ivarsson

|||

Hi,

thanks for the answer .

I asked if there is an option to use the hierarchy of AS?

I know how to produce RS parent-child reports.

is this the only option?

Disable SQL 2005 on startup

Is there a way to disable SQL server 2005 from starting up automatically in
Vista? It is not listed in startup tab in MSCONFIG or on any option
screen.. But the database always loads upon bootup.. I want to start it
manually only.. how do i do this?
thanks!Either use SQL Server Configuration Manager or the "Services" windows applet.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Sabian Smith" <22@.spamhere.com> wrote in message news:%23ShFnXxiIHA.4376@.TK2MSFTNGP05.phx.gbl...
> Is there a way to disable SQL server 2005 from starting up automatically in
> Vista? It is not listed in startup tab in MSCONFIG or on any option
> screen.. But the database always loads upon bootup.. I want to start it
> manually only.. how do i do this?
> thanks!
>

Disable auto mapping by matching column names?

Hi,

If you use a component that has a column mapping tab (most do) then you know that the component will try and map input and output columns automatically by name.

Is there a way to disable this feature when writing your own custom components? There is already a manual way to do this: rightmouse in the mappings tab of a component and chosen "Map Items By Matching Names". I find it is less helpful to auto-map initially because the designer tends to not think about the mappings.

A way of turning of auto-mapping in existing components would be cool too!

Cheers,

Martin

There is no way to turn it off currently You can easily remove all the mappings, though. This is the first request I hear for turning it off. Usually, people asked for additional smart mapping options.

Thanks,

Bob

|||

Bob,

Thanks for the reply. What I find is designers get lazy and don't question the auto-mapping. Then mistakes happen which they find hard to troubleshoot because their brains weren't involved in the mapping - it's not a step they try to replay as they look for problems.

Because it happens automatically when you switch to the map pane, I wonder if it's the SSIS equivalent of Clippy announcing your Word doc "looks like you're writing a letter" and reformatting it automatically without you getting a chance to say no! :-)

Further clever mapping options would be great, but I'd suggest the designer needs to make the conscious step of making it happen.

All the best,

Martin

Disable auto mapping by matching column names?

Hi,

If you use a component that has a column mapping tab (most do) then you know that the component will try and map input and output columns automatically by name.

Is there a way to disable this feature when writing your own custom components? There is already a manual way to do this: rightmouse in the mappings tab of a component and chosen "Map Items By Matching Names". I find it is less helpful to auto-map initially because the designer tends to not think about the mappings.

A way of turning of auto-mapping in existing components would be cool too!

Cheers,

Martin

There is no way to turn it off currently You can easily remove all the mappings, though. This is the first request I hear for turning it off. Usually, people asked for additional smart mapping options.

Thanks,

Bob

|||

Bob,

Thanks for the reply. What I find is designers get lazy and don't question the auto-mapping. Then mistakes happen which they find hard to troubleshoot because their brains weren't involved in the mapping - it's not a step they try to replay as they look for problems.

Because it happens automatically when you switch to the map pane, I wonder if it's the SSIS equivalent of Clippy announcing your Word doc "looks like you're writing a letter" and reformatting it automatically without you getting a chance to say no! :-)

Further clever mapping options would be great, but I'd suggest the designer needs to make the conscious step of making it happen.

All the best,

Martin