Answer Questions

• Jeanet Security between BSM and SSAS

  Hi, I have a SSAS cube with roles enforced, i would like to show some metrics through BSM 2005 but with SSAS roles enforced. In other words i would like to have the BSM final user authenticated in SSAS in order for him to have the correct data permissions (dimension filters). The scenario im looking for is 3000 users on the same scorecard which one with their values filtered by an organisation dimension (cube security already in place). Is there anyway of getting the USERNAME function whithin BSM in order to make a MDX dynamic filter Thanks, Jorge Sietra If BSM/SharePoint and SSAS are on separate servers, you may need to use Kerberos (at least that was the case with the ...Show All

• EWL How to select this ?

  SELECT CAST(MONTH(DateCol) AS VARCHAR(2)) + '/' RIGHT(CAST(YEAR(DateCol) AS VARCHAR(2)),2) SUM(CASE WHEN Work = 'Design' THEN 1 ELSE 0 END) as Design, SUM(CASE WHEN Work = 'Programming' THEN 1 ELSE 0 END) as Programming From SomeTable GROUP BY CAST(MONTH(DateCol) AS VARCHAR(2)) + '/' RIGHT(CAST(YEAR(DateCol) AS VARCHAR(2)),2) The above query works fine . but when i try to change to below format : SUM(CASE WHEN Work = 'Design' THEN 1 ELSE 0 END) as Design in this query i how to insert this SUM(CASE WHEN Work = 'Design' THEN (select distinct(act_point) from act_table) where act_id='1000' ELSE 0 END) as Design when i use this i get the following error. Cannot perform an aggregate function on an expression containing an aggre ...Show All

• Sweeps78 Changing Date

  Hello all, I have a question. I am fairly new to all of this, so bear with me if it is something simple (as I kinda hope it is). In SSRS, I have a report that runs against a SQL '05 DB. The DB tables are created with a SSIS package gathering information from an AS/400 DB2 database. The package and report run fine. One of the columns in the table is for a date (date of birth). The SSIS package gathers the column information and inserts it into SQL Server as a Decimal datatype (Decimal 6,0). The dates (decimals ) are now in the format 40207, as they were on the 400, where that specific date would be April 2, 2007. 120707 would be December 7, 2007 and so on. I would like to format the date to be mm/dd/yy or even m/dd/yy for the "si ...Show All

• Jan Kučera Fixed header

  Hello! I have a report that the users reach from an url. In the url I have rc:parameters = false. That part works fine. But when I use rc:parameters = false, the property fixed header doesn't seem to work. If I run the report from the report server it works fine, but not from the url. Any ideas /C Fixed headers don't work if the url access displays more than one page at the same time. The best way to ensure that fixed headers work is to run with rc:toolbar=true Ok, I see... I tried with "rc:toolbar=true" and set all parameters to "hidden" instead. It works fine, even though it feels a little bit slower when the report is rendering. Another ...Show All

• Tom Richards Problem in changing Account Name, Password

  Hi I installed SQL Server 2005 Express Edition. When I try changing the account name, password in the SQL Server Configuration Manager, i.e. by clicking on Apply, the SQLEXPRESS restarts and the password gets replaced by a longer password. Also the user name gets prefixed with "./". Any help on this will be highly appreciated. Another query: Do we have the query analyser (gui or command line) kind of thing in Express Edition Also where can I get a proper documentation of doing elementary things in setting up a database, like creating a database, adding a user, etc) Thanks and Regards Roopesh A few additional notes, if you've only downloaded Express Edition (not Advanced Services) you can get Management Studio Express separately fr ...Show All

• Jun_1111 Copy cube from a DB to another one

  Hi, I would like to copy a cube and its content from a database to another one. The first database is the one used for production and the second will be used to archive the old cubes. Is there a specific way to deal with this kind of issue Thanks in advance for your support. Rgds, Juan Hello! You have not told about what version you are using, AS2000 or SSAS2005 With SSAS2005 you simply change this is the properties of the project and deployment. This is in the solution explorer of BI-Developer Studio. In AS2000 you can use archive and restore from one machine to another as long as the data source name is the same. Regards Thomas Ivarsson ...Show All

• neto Error 3154: The backup set holds a backup of a database other than the existing 'xx' database.

  HELP! This is happening with a restore to SS 2005 from a SS2000 backup. This article says to use the 'WITH REPLACE' clause. The SS2005 management studio does not seem to allow this via the GUI. http://msdn2.microsoft.com/en-us/library/aa238217(sql.80).aspx Did you use the overwrite flag in the GUI if the database already existed HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Hi all, I am facing this problem, when i try to restore a file in a database. Scenario Database ABC with 1 Filegroup and 8 Files and 1 Log. Now i want to restore the Database ABC to another Server as ABC. due to space constraint i have thought o ...Show All

• anu_ooo Question about "Connect to the sql server 2000 installed on windows xp sp2"

  Hi I have another question now. As the topic said, my sql server 2000 installed on windows xp sp2, the computer's name is "ADMIN" and the server 2000's name is "ADMIN". When i startup the sql server 2000, it just listening on shared memory and name pipes, not including the "TCP/IP" . So i can not connect to the sql server using the port 1433. Some people said that the reason was the system's firewall. I also found some supports on the websites 'www.support.microsoft.com'. It said that you can set the port 1433 or the sqlservr.exe to the execption. I also do that, but still not works. Is there any things i forget and how can i solve the problems! Thanks for advances. Try disabling your ...Show All

• Chimme Schedule SQL Express BAckup using SQL DMO

  Is it possible to schedule SQL Express BAckup using SQL DMO do I need to use WScript.Shell,SQLDMO.SQLServer,SQLDMO.Category,SQLDMO.Job, SQLDMO.JobStep,SQLDMO.JobSchedule Because SQL Express doesn't include the SQL Server Agent the jobs you are creating can't be executed. You'd be best served to use Windows Scheduler to run the programs performing your backups. I would like to schedule back up programatically in ASP. If I want to use WSH , It can only run VBScript and JScript files that are .vbs or .js. It does not run .asp files. If you wish to run the VBScript code contained in an .asp file in the WSH environment, you need to remove all of the HTML tags; the <% and %> tags, and rename ...Show All

• U_T_A Saving maintenance plan failed?

  =================================== Saving maintenance plan failed. =================================== One or more arguments are invalid ------------------------------ : Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword) Microsoft.SqlServer.Management.DatabaseMaintenance.MaintenancePlan.Save() Microsoft.SqlServer.Management.MaintenancePlanWizard.MaintenancePlanWizardForm.PerformActions() Stivan, I am trying to reproduce the problem you are facing. It will greatly help if you can provide information about your machine configuration and the exact upgrade sequence T ...Show All

• AlanKohl SSIS - Connection String Issue

  Hi I have been trying to resolve a connection string issue all day, and havent figured out whats the problem. I keep getting the Acquire Connection error everytime I run my package. Can you someone review the format of my connection string, and confirm that it is indeed the correct format: I have two conn strings specified in my config file, one is to connect to a remote database and one is for local. I have validated the connectivity from my server to these databases via Management Studio, and it seems to connect fine. But when I run my package it keeps failing. SQL Server Authentication(Remote Database Server): Data Source=server_name;Username=useraccount;Password=xxxxx;Initial Catalog=dbname;Provider=SQLNCLI.1; Window ...Show All

• JB1863 Upgrade SQL Server 2K to SP4

  One of our windows service logged following events Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17055 Date: 1/31/2006 Time: 7:56:04 AM User: N/A Computer: blah blah Description: 17066 : SQL Server Assertion: File: <rowset.cpp>, line=3260 Failed Assertion = 'm_cILockBytesOpen == 0' ================================================================== Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17055 Date: 1/31/2006 Time: 7:56:04 AM User: N/A Computer: blah blah Description: 18052 : Error: 1203, Severity: 20, State: 1 Process ID 53 attempting to unlock unowned resource KEY: 11:2041058307:1 (8e02b4254032) ================================================================= ...Show All

• Pintoo Khaira Problems with merging raw files opened as variables

  I have a group of parallel dataflow tasks that produce raw file outputs that I then want to merge together in a subsequent task. I use variable names for the raw file outputs because I want to the path to the files to be easy to configure for different deployment environments. Therefore, I've got a package scoped variable called pkgRawFileFolder and in each of my parallel tasks my raw file destination is derived from another variable scoped at the task level, called tskRawFileOutput which is evaluated as an expression equal to [User::pkgRawFileFolder]+"/RawFile_1" or similar (the name of the rawfile isn't important as long as each parallel task uses a different name). In the container task that performs the merge, I want a Foreac ...Show All

• donkaiser How do I send RS parameter to XML query?

  I Have this web service method: [ WebMethod ] public DataSet EeoReport( DateTime start, DateTime end) {} I have this XML query that sends blanks to start and end and properly gets my data. <Query> <ElementPath IgnoreNamespaces="True"> EeoReportResponse {}/ EeoReportResult/diffgram{}/ DataSetName {}/TableName {Field1, Field2, Field3, Field4, Field5, Field6, Field7, Field8} </ElementPath> <SoapAction>http://services.mydomain.com/EeoReport</SoapAction> <Method Namespace=" http://services.mydomain.com " Name="EeoReport"> </Method> </Query> How do i add RS parameters to this query to represent start and end in the above webmethod... http://m ...Show All

• Hobbit666 Encryption and query performance

  I am trying to implement encryption but have run into some serious performance issues. I am required to encrypt the SSN in our database. In and of itself, this is not a problem. The problem comes in because there is also a need to be able to query the table based on the SSN. Since the SSN is encrypted, the query basically performs an index scan, decrypting each value as it goes along. As a result, the query for one record out of 10 million records in the table takes three minutes. It needs to occur immediately. If I could encrypt my SSN parameter and then compare it to the encrypted value in the column, it would work fine. Unfortunately, everytime you encrypt a particular value, the resultant encrypted value is different. Hence, I have ...Show All