Customized Schema

Hi,
Is there any way to specify an XML Schema to SQL Server so when i use "For XML", SQL Server return data in XML Format in the Schema i have defined.
For example. I need sql server to return XML as
<object name="<table_name>">
<property name="<column_name>" value="<column_value>"/>
<property name="<column_name" value="<column_value>"/>
</object>
is it possible ? is there any other work aournd ?
Thanks in advance.
Regards,
Hatim Ali.
You should be able to do that with For XML Explicit. Another option would
be to create a mapping schema and use the XPath query from SQLXML to do the
queries for you. This also uses For XML Explicit but the XPath logic
generates the query so you don't have to.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Hatim Ali" <HatimAli@.discussions.microsoft.com> wrote in message
news:63B74B0A-E902-45F8-9255-4293BD18C70F@.microsoft.com...
> Hi,
> Is there any way to specify an XML Schema to SQL Server so when i use "For
> XML", SQL Server return data in XML Format in the Schema i have defined.
> For example. I need sql server to return XML as
> <object name="<table_name>">
> <property name="<column_name>" value="<column_value>"/>
> <property name="<column_name" value="<column_value>"/>
> </object>
> is it possible ? is there any other work aournd ?
> Thanks in advance.
> Regards,
> Hatim Ali.
|||Roger's solution works if you want <colname>value</colname> or exactly now
all your column names in advance.
We do not provide a general pivoting mechanism in T-SQL for SQL Server 2000
(and the PIVOT in 2005 has some limits).
If you need a completely generic way, you best use FOR XML for getting the
<colname>value</colname> format and then use an XSLT stylesheet to transform
it into the generic form below.
Best regards
Michael
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eIfu5RzaEHA.3480@.TK2MSFTNGP11.phx.gbl...
> You should be able to do that with For XML Explicit. Another option would
> be to create a mapping schema and use the XPath query from SQLXML to do
> the queries for you. This also uses For XML Explicit but the XPath logic
> generates the query so you don't have to.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Hatim Ali" <HatimAli@.discussions.microsoft.com> wrote in message
> news:63B74B0A-E902-45F8-9255-4293BD18C70F@.microsoft.com...
>

Custom Zoom Factor

How'd
I was asked by a client if they could specify a custom zoom factor is this possible?
If not can it be incorporated into next SP or Version?
Thanks in Advance
SheaThe Zoom supported by Reporting Services is the standard Zoom supported by
IE. You can employ any numeric value and then also Page Width and Whole
Page.
What is the custom Zoom factor your client wishes to use?
Is your client accessing reports through Report Manager or through a custom
application?
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Shea Strickland" <SheaStrickland@.discussions.microsoft.com> wrote in
message news:21322E4C-766B-4812-B1BA-6D096BA6753D@.microsoft.com...
> How'd
> I was asked by a client if they could specify a custom zoom factor is this
possible?
> If not can it be incorporated into next SP or Version?
> Thanks in Advance
> Shea|||I guess the client wants to be able to type a % in the drop down in the builtin control just like other microsoft products. eg 79%
The application is a custom web app that just uses the builtin reportparameter control and navigation control (export etc)
Thanks for you help
Shea
"Bryan Keller [MSFT]" wrote:
> The Zoom supported by Reporting Services is the standard Zoom supported by
> IE. You can employ any numeric value and then also Page Width and Whole
> Page.
> What is the custom Zoom factor your client wishes to use?
> Is your client accessing reports through Report Manager or through a custom
> application?
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Shea Strickland" <SheaStrickland@.discussions.microsoft.com> wrote in
> message news:21322E4C-766B-4812-B1BA-6D096BA6753D@.microsoft.com...
> > How'd
> >
> > I was asked by a client if they could specify a custom zoom factor is this
> possible?
> > If not can it be incorporated into next SP or Version?
> >
> > Thanks in Advance
> > Shea
>
>

Custom Series Color Problem

I am using SP1 and am trying to use the new custom color feature for chart
series.
The problem is that I want to specify a transparent color (Alpha = 50%).
Is there any way of doing this? It seems that you can only enter colors that
have RGB values, not ARGB values. (The System.Drawing.Color.FromArgb function
does not work in an expression).
At the moment, I am using the Semi-Transparent palette, but would like to
choose the colors myself as opposed to having them chosen for me.
--
cjARGB colors are not supported.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"CJ" <CJ@.newsgroup.nospam> wrote in message
news:E7870F65-DE71-4D39-9D47-748EB3FE7444@.microsoft.com...
>I am using SP1 and am trying to use the new custom color feature for chart
> series.
> The problem is that I want to specify a transparent color (Alpha = 50%).
> Is there any way of doing this? It seems that you can only enter colors
> that
> have RGB values, not ARGB values. (The System.Drawing.Color.FromArgb
> function
> does not work in an expression).
> At the moment, I am using the Semi-Transparent palette, but would like to
> choose the colors myself as opposed to having them chosen for me.
> --
> cj|||Will this be available in a future version?
"Lev Semenets [MSFT]" wrote:
> ARGB colors are not supported.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "CJ" <CJ@.newsgroup.nospam> wrote in message
> news:E7870F65-DE71-4D39-9D47-748EB3FE7444@.microsoft.com...
> >I am using SP1 and am trying to use the new custom color feature for chart
> > series.
> > The problem is that I want to specify a transparent color (Alpha = 50%).
> > Is there any way of doing this? It seems that you can only enter colors
> > that
> > have RGB values, not ARGB values. (The System.Drawing.Color.FromArgb
> > function
> > does not work in an expression).
> > At the moment, I am using the Semi-Transparent palette, but would like to
> > choose the colors myself as opposed to having them chosen for me.
> > --
> > cj
>
>|||It is on the wishlist for a future version.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"CJ" <CJ@.newsgroup.nospam> wrote in message
news:B6B8C17A-19FC-4A5A-BDA3-24C7E5A962B4@.microsoft.com...
> Will this be available in a future version?
> "Lev Semenets [MSFT]" wrote:
> > ARGB colors are not supported.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "CJ" <CJ@.newsgroup.nospam> wrote in message
> > news:E7870F65-DE71-4D39-9D47-748EB3FE7444@.microsoft.com...
> > >I am using SP1 and am trying to use the new custom color feature for
chart
> > > series.
> > > The problem is that I want to specify a transparent color (Alpha =50%).
> > > Is there any way of doing this? It seems that you can only enter
colors
> > > that
> > > have RGB values, not ARGB values. (The System.Drawing.Color.FromArgb
> > > function
> > > does not work in an expression).
> > > At the moment, I am using the Semi-Transparent palette, but would like
to
> > > choose the colors myself as opposed to having them chosen for me.
> > > --
> > > cj
> >
> >
> >

Custom Rollup formula and All Member Formula property

For SSAS 2000 ,to specify a custom rollup formula in any level except the All Level, the Custom Rollup Formula property of the level has to be used.

Then to specify it for the All Level the All Member Formula property of the dimension has to be used.

But at SSAS 2005, to specify it for the All Level , I dont know where is the All Member Formula property of the dimension .

Anyone know where is the All Member Formula property of the dimension at SSAS 2005.

Thanks

How about making a cube MDX script assignment to the Root() of the dimension?

SQL Server 2005 Books Online

Working with Custom Member Formulas

Note: To apply an MDX expression to members of a particular level instead of to members of all levels based on a particular attribute, you can define the expression as an MDX script on the level.

|||

May I know why the CustomRollupColumn property or UnaryOperatorColumn property after configure can not be remove if I dont want it to be done this way. I tried to remove from table ID and columnid as show below, but I not see none or any other setting to remove it .I only able to change the setting , but not remove the setting.

UnaryOperatorColumn

- Sources

--TableID

--ColumnID

CustomRollupColumn

- Sources

--TableID

--ColumnID

For this moment,I just able have to delete the dimension and recreate it again because of fail to remove the above property setting.

Anyone know how to remove the setting.Thanks

|||

Anyone know about above question?

Appreciate that anyone able to provide opnion.

Thanks

Custom Bar Chart colors?

I am also looking for a way to specify my own list of colors for bars in a
bar chart. Please let me know if anyone has a solution for this.
Thanks Again,
AndyHowdy,
http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx
(Courtesy of Brian Welcker)
HTH,
Sean G.