Named set is not working in excel

Hi All,

I have created the named set to get the top 4 referers for my products.

But it is not working as expected.I am using Ecel 2007 as reporting UI using Pivot tables.

The referers are in rows and product is in filter.

Say I want the top referers (google.com,altavista.com...etc) for VB (or) VC++ or SQL 2005 ....etc

Please suggest me how I can do this i.e arrange in order and vary with change of product.

I have three tables Dim_Product, Dim_Referer, Fact table

The content of this new named set would be:

{([Dim Referer].[name category].Members,4,[Measures].[value])}

Rgds

Sai

Named sets created in the MDX Script are static - they are evaluated only once. Therefore changing the current product won't affect the content of the named set.sql

Named Set in Excel Pivot Table Displays as Enumeration

Pardon me if this is really an Excel 2007 Pivot table question. I have a named set defined in the cube as:

CREATE SET CURRENTCUBE. [Team Building Overall]

AS {[Question].[Short Name].[Q-02],

[Question].[Short Name].[Q-03],

[Question].[Short Name].[Q-05],

[Question].[Short Name].[Q-06],

[Question].[Short Name].[Q-08],

[Question].[Short Name].[Q-13],

[Question].[Short Name].[Q-17],

[Question].[Short Name].[Q-18],

[Question].[Short Name].[Q-21],

[Question].[Short Name].[Q-30],

[Question].[Short Name].[Q-31]};

And can display measure values for this set as whole in Proclarity with:

SELECT { [Measures].[Average]} ON COLUMNS ,

{ [Corporate Hierarchy].[Hierarchy].DEFAULTMEMBER } ON ROWS

FROM [360 Training Survey]

WHERE ([Team Building Overall], [Test Month].[Test Month].&[200704] )

CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, ACTION_TYPE

In Excel 2007, unfortunately I can not use this set as a filter as I can in Proclarity. Rather, the best I can accomplish is to display this as 11 different columns, one for each member of this named set.

Any suggestions ?

Anyone ?

I figure I can create a calculated measure in the cube named [Team Building Overall Average] which is defined as ([Team Building Overall],[measures].[Average]), but this seems a bit klutzy, especially given that I have eight sets and six measures, thus resulting in a total of 48 calculate measures I need to create.

|||

You could create a measure independant calculated member in the Question dimension as follows.

CREATE MEMBER CurrentCube.[Question].[Short Name].[Team Building Overall] AS AGGREGATE([Team Building Overall])

If the only reason that you have the sets is for filtering you could put the set definition inline in this memeber, otherwise you could leave them separate.

Name multiple sheets in excel export?

I have a report that when exported to Excel creates multiple sheets. Im
doing this on purpose. I wanted know if anyone new a way to
automatically name the Sheets in the Excel export? I wanted to name
them from a field on the report.I don't believe this is possible in the current versions of Reporting
Services. It seems like a functionality that would have a great deal
of value for reporting purposes, so hopefully MS will include this
feature in a future service pack.
pichula wrote:
> I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.|||I'm pretty sure you can't do this. I'm very sure you couldn't do it with RS
2000 (tried to find info about it myself a while ago), and I don't think you
can do it in RS 2005 either.
A pity, really, as it would be very usefull!
Kaisa M. Lindahl Lervik
"pichula" <kansas4451@.yahoo.com> wrote in message
news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
>I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.
>|||Thanks for your replies. If this is not possible in RS 2005, does
anybody know about any workaround to this problem? Maybe using Excel
macros, etc.
elPablo
Kaisa M. Lindahl Lervik wrote:
> I'm pretty sure you can't do this. I'm very sure you couldn't do it with RS
> 2000 (tried to find info about it myself a while ago), and I don't think you
> can do it in RS 2005 either.
> A pity, really, as it would be very usefull!
> Kaisa M. Lindahl Lervik
>
> "pichula" <kansas4451@.yahoo.com> wrote in message
> news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
> >I have a report that when exported to Excel creates multiple sheets. Im
> > doing this on purpose. I wanted know if anyone new a way to
> > automatically name the Sheets in the Excel export? I wanted to name
> > them from a field on the report.
> >|||Have you tried to write a post process that runs on your excel sheet and
renames the exported sheets?
=-Chris
"pichula" <kansas4451@.yahoo.com> wrote in message
news:1162321874.757668.47520@.e64g2000cwd.googlegroups.com...
>I have a report that when exported to Excel creates multiple sheets. Im
> doing this on purpose. I wanted know if anyone new a way to
> automatically name the Sheets in the Excel export? I wanted to name
> them from a field on the report.
>

My graph colors are ignored!

I have an SSRS report that contains 4 bar charts. In the properties for
each chart I set the graph palette to "excel", and when I click on
preview to see the report, I get exactly the colours i wanted in the
report.
However, when I upload the rdl file to the report server, it seems to
ignore these colours! For the first chart, it does use the excel
palette, but the other charts all use a different palette, and no
matter what color palette I choose, they are completely ignored in the
report!! I have tried deleting the report from the report server and
uploading it again, but no joy.
Can anyone help? Is this a bug with SSRS report server? We are using
the 2000 version.
Many thanks.
Frustrated SSRS charter.I sorted it myself!
I removed all traces of "color" settings from the rdl, and moved the
charts around a bit, and that seemed to do the trick.
Weird!