Calculated Member help

Hi, I have a calculated member that computes the Sales per week for any given level. I am using a time dimensiona and a sales dimension. The time dimension has these levels: Year, Quarter, Month, and Weeks. I am using this formula

[Measures].[Sales]/Descendants([TIME_WEEK_DIM],[TIME_WEEK_DIM].[Time Week Desc]).count

The problem with this is that it works only if the user select a single time member. I am using Excel as frontend and I fixed the pivot table in such a way that Sales is on the column, and Store is on the Rows. The time dimension is on the top serving as filter (Page axis). Because you can choose multiple dimension member in the dropdown boxes of any dimension in Excel, I am having trouble making it work in these scenario. It only works if you select one time member at a time. Please help.I don't fully understand what you are trying to do, but since the database server is returning a simple dataset to your Excel pivot table, the problem would appear to be with the pivot table and not the query or table you are using. When you filter the pivot table you are fiiltering its stored snapshot of the query results. It does not pass the parameters back to the database server.

blindman|||Hi, thnks so much for the reply. Anyway, to make it clear to you:

I'm using an Analysis Service Cube as my backend and Excel Pivot table as my frontend.

I have two dimension in my cube: 1. Time(Yr, Qtr, Month, Week) and 2. Store

I have two measures: 1. Sales and 2. Sales per week (this measure is a calculated member

The formula I use to make the Sales per week measure is:
[Measures].[Sales]/Descendants([TIME_WEEK_DIM],[TIME_WEEK_DIM].[Time Week Desc]).count

Here's my setup in Excel: The sales is broken down by store and the time is on top acting as a filter

Time: 2003

Store Sales Sales/Week
Store1 100 25
Store2 200 12

My problem occurs evrytime the user selects more than one Time value to filter on (like all Jan AND Feb data). It works only if one time value is selected at a time. When user chooses more than 1 time value, the Sales/Week data appears as: #Num!|||Sorry smb, but I don't have experience with data cubes syntax. Hopefully now that your post is at the top of list someone else will check it out and give you an answer!

blindman|||Thnks anyway blindman :)

byte by byte level replication versus sql server replication

Hi
Can anyone give me a helpful link or information on the pros and cons on the
"byte by byte level replication" versus "sql server transaction replication".
Requirement:
I need upto second replication to a geographically remote site, so I was
considering sql server transactional replication versus byte by byte data
level replication between the geographically remote servers.
What are the pros and cons?
Any kind of information would be of help.
Thanks
For software solutions - Byte by byte is not good for write intensive
operations - I find it doesn't scale well.
For hardware solutions look at products like EMC's SRDF. Its very expensive.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:D3925A66-6ED5-4795-AE50-B5BA56F6D7B4@.microsoft.com...
> Hi
> Can anyone give me a helpful link or information on the pros and cons on
the
> "byte by byte level replication" versus "sql server transaction
replication".
> Requirement:
> I need upto second replication to a geographically remote site, so I was
> considering sql server transactional replication versus byte by byte data
> level replication between the geographically remote servers.
> What are the pros and cons?
> Any kind of information would be of help.
> Thanks
>
>
|||Hi
When you say software solutions, what does it mean? It has to have a
software on a hardware box even EMC SRDF is a remote replication software
solution.
Is the Data Replication Manager (DRM) from HP on XP hardware comparable to
EMC's SRDF?
can you please clarify the hardware and software solutions difference.
Thanks
"Hilary Cotter" wrote:

> For software solutions - Byte by byte is not good for write intensive
> operations - I find it doesn't scale well.
> For hardware solutions look at products like EMC's SRDF. Its very expensive.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Pari" <Pari@.discussions.microsoft.com> wrote in message
> news:D3925A66-6ED5-4795-AE50-B5BA56F6D7B4@.microsoft.com...
> the
> replication".
>
>
|||A software solution which does a byte by byte copy is DoubleTake. I believe
it has a driver which sits between your os and the disk array and monitors
byte activity, then it copies deltas to the destination server.
Data Replication Manager sounds similar to EMC's SRDF, but I am not sure if
either can run on XP.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Pari" <Pari@.discussions.microsoft.com> wrote in message
news:46724538-E7A1-46FC-A6BF-A786DF7B4508@.microsoft.com...[vbcol=seagreen]
> Hi
> When you say software solutions, what does it mean? It has to have a
> software on a hardware box even EMC SRDF is a remote replication software
> solution.
> Is the Data Replication Manager (DRM) from HP on XP hardware comparable to
> EMC's SRDF?
> can you please clarify the hardware and software solutions difference.
> Thanks
> "Hilary Cotter" wrote:
expensive.[vbcol=seagreen]
on[vbcol=seagreen]
was[vbcol=seagreen]
data[vbcol=seagreen]