RelativeTime

Hi,

I have a traditional Time dimension, MatchDate (Year - Qtr - Month). I have created a dummy dimension RelativeTime in trying to copy the Cognos functionality. I have tried to created a calculated member:

SUM(PeriodsToDate([MatchDate].[Year]),([RelativeTime].[Relative Time].[Current]))

but it results in a errormess:

Formula error - cannot find dimension member

("[RelativeTime].[Relative Time].[Current]")) in a name-binding function.

Any idea anyone?

Hi

After modifying the MDX syntax its working fine:

SUM(PeriodsToDate([MatchDate].[Year]),([RelativeTime].[Relative Time].&[1]))

This is giving me the YTD total, how do I create a Previous YTD ? I will try using ParallelPeriod

Larra

RelativeTime

Hi,

I have a traditional Time dimension, MatchDate (Year - Qtr - Month). I have created a dummy dimension RelativeTime in trying to copy the Cognos functionality. I have tried to created a calculated member:

SUM(PeriodsToDate([MatchDate].[Year]),([RelativeTime].[Relative Time].[Current]))

but it results in a errormess:

Formula error - cannot find dimension member

("[RelativeTime].[Relative Time].[Current]")) in a name-binding function.

Any idea anyone?

Hi

After modifying the MDX syntax its working fine:

SUM(PeriodsToDate([MatchDate].[Year]),([RelativeTime].[Relative Time].&[1]))

This is giving me the YTD total, how do I create a Previous YTD ? I will try using ParallelPeriod

Larra

Relationship to UserId

Hi there everyone, this is my first post so go easy on me :)

Basically I am trying to get my database to copy the value in the UserId (unique identifier field) from the aspnet_Users table to a foreign key UserId in a table called userclassset. I have made this field the same datatype and created a relationship between the two. Unfortunately, when I add a user using the ASP.Net configuration tool it does not automatically copy this value into my own custom table. I have noticed it is however automatically copied into the aspnet_Membership table. Any pointers on how to solve this would be great!

Thanks :)

ascension:

?I have noticed it is however automatically copied into the aspnet_Membership table. Any pointers on how to solve this would be great!

This is because when you?use?.NET2.0?built-in?function?to create user,?the?aspnet_Users_CreateUser?stored?procedure?is?called.?This?stored?procedure?will?not?only?insert?a?row?in?aspnet_users?table,?but?also?do?some?operations?on?aspnet_Memebership?table,?you?can?use?sp_helptext?to?view?the?definition:

sp_helptext aspnet_Users_CreateUser

So if you want to insert some row into your own custom table, you can either: alter the aspnet_Users_CreateUser to add your own statements (preferred); orcreate a?insert trigger?on?the?aspnet_users?table|||Brilliant, worked perfectly. Thanks :)

Reinstall RS Client?

Hi,
I have purchased a new copy of SQL Server for running Reporting Service as
the Evaluation copy has expired.
I have installed Visual Studio with RS client on a workstation as I don't
want to install Report Designer on the Server.
I would like to know is it necessary for me to uninstall the Evaluation Copy
RS Client on my workstation before installing the new RS Client ?
Your advice is sought.I am pretty sure the evaluation expiration is only the server part of RS,
not the design tools. Are you getting a message saying that it has expired
when you try to design? You should still be able to design and preview. If
that is the case (I am trying to remember what I did but I don't think I did
anything with the client tools). Unless you have a problem my suggestion is
to leave the designer alone. After installing the new server you should
download SP2 and install that at both the server and the client.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:%239RZUnfsFHA.3424@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have purchased a new copy of SQL Server for running Reporting Service as
> the Evaluation copy has expired.
> I have installed Visual Studio with RS client on a workstation as I don't
> want to install Report Designer on the Server.
> I would like to know is it necessary for me to uninstall the Evaluation
> Copy RS Client on my workstation before installing the new RS Client ?
> Your advice is sought.
>

Register SQL Server BCP.exe utility

Dear All,

I am facing problem related bulk copy program utility. I have both SQL Server 2000 and SQL server 2005 installed on my PC. The current registered BCP.exe is of version 8.0. When i give command BCP.exe with database of SQL Server 2005 on command prompt it actually check the database in SQL Server 2000. The problem resolved if i the complete directry path is selected i-e C:\Program Files\Microsoft SQL Server\90\Tools\Binn. But i want to enter command on every selected directry on command prompt.

Regards

Haseeb Ahmad

I'm not certain what you're asking here - but if you want the 2005 version of BCP to be the default, change your PATH variable in the operating system to have the binary directories for SQL Server 2005 to be above the ones for SQL Server 2000. You can also create a batch file in the operating system to use instead of calling BCP.EXE that has the full path in it if you don't want to change the PATH variable.|||

Thanks a lot for your help. After changing the path in enviornment variable, the problem has been resolved.

Once again thank you for your cooperation.

Haseeb Ahmad