Answer Questions

• elainel311 Using UPDATE CUBE for override cells with CustomRollup?

  Hi all, In our task I'm using CustomRollup for define logic for calculate some not leaf members, for example: CoalesceEmpty ( [Accounts].[AccountsTree].[1002G].DataMember, ... It allows to have in FactTable, for not leaf members, the values, those used instead of aggregated from children. Now I'm trying use UPDATE CUBE for assign a Datamember's value for non leaf member: UPDATE CUBE ... SET ([Accounts].[AccountsTree].[1002G].DataMember,... ) = ... It works correct if member hasn't CustomRollup formula and doesn't work if CustomRollup exists. So, the question: Can I use UPDATE CUBE for override Datamember's value for non leaf member with CustomRollup Thank you in advance, Stas Mos ...Show All

• Sam Jost Grand Total Needed

  I have two subreports (Revenue and Expense) that each have subtotals. This works just fine, but I need a Grand Total that would sum the two subtotals. How would I go about doing this So it looks something like this: Revenue Report (matrix) Subtotal Expense Report (matrix) Subtotal <~~~~ Need Grand Total here. Greg, I added a textbox to the bottom of my 2 matrix to make my Grand total align correctly. Ham Greg, This should work for you. Sum(Fields!Counter.Value, "DataSet1" )+ Sum(Fields!Counter2.Value, "DataSet2" ) Ham I'm not quite sure how to implement that since my revenue and expense report have a column for each month in the ...Show All

• Trevor E Hilder Best practice configuring Visual Studio Solution for .SDF databases

  Hello, In our company we haven't tamed Visual Studio yet for the part of configuring the application database. Therefore I was wondering if there is someone that can give me hints or clues on what the best practice is for configuring Visual Solution to handle an SDF database (SQLCE 3.0). I have search a bit on the internet and this forum, but couldn't find a decent how-to or best practices guide that copes with this specific problem. As a matter of facts, i am also curious for guidelines and tips on the best way to configure and manage SQL Server databases under Visual Studio. I guess (read as hope ) that the configuration of a mobile and full blown database will have some overlaps somehow. I've found the Database Proj ...Show All

• gshaf Remote Connection Not Allowed

  Just installed SQL Express but cannot connect since it says Remote Connections are not allowed ! This worked before. I have tried different protocols and even SQL Authentication. No luck here and I've been up all night... You could also look at this Microsoft KB ... Look at this here: http://www.sqlserver2005.de > Screencasts > Enable Remote Connections HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- Awesome Jens - thanks for the link ! ...Show All

• pappascd BACKUP LOG cannot be performed because there is no current database backup.

  Hi, I have a MS SQL Server 2005 Enterprise Edition 9.0.2153 which manages my BizTalk Server 2006 Databases. The BizTalk server installer automatically creates a job named Backup BizTalk Server (BizTalkMgmtDb) which should back up the databases and transaction protocolls. The SQL Server Agent runs under domain-administrator account which has full access to my backup directory D:\backups. The job executes the following steps: Step 1: BackupFull: Command: exec [dbo].[sp_BackupAllFull_Schedule] 'd' /* Frequency */, 'BTS' /* Name */, 'D:\Backups' /* location of backup files */ Step 2: MarkAndBackupLog Command: exec [dbo].[sp_MarkAll] 'BTS' /* Log mark name */, 'D:\Backups' /* location of backup files */ My chal ...Show All

• freestar Formatting Date as integer

  I want to for that format the date in YYYYMMDD and MMDDYY, with no '-' as data type is integer I have used the following code (not the conversion function as I don’t need Hyphen '-') for YYYYDDMM SET @DATE = CONVERT ( INT ,( CONVERT ( VARCHAR ( 4 ), DATEPART ( YYYY ,GETDATE())) + CONVERT ( VARCHAR ( 4 ), DATEPART ( MM ,GETDATE())) + CONVERT ( VARCHAR ( 4 ), DATEPART ( DD ,GETDATE())) )) & for MMDDYY SET @DATEUS = CONVERT ( INT ,( CONVERT ( VARCHAR ( 3 ), DATEPART ( MM ,GETDATE()))+ CONVERT ( VARCHAR ( 3 ), DATEPART ( DD ,GETDATE())) + SUBSTRING ( CONVERT ( VARCHAR ( 4 ), DATEPART ( YY ,GETDATE())), 3 , 4 ) )) I am getting the result YYYYMMDD= 200688 MMDDYY =8806 ...Show All

• Stags Quicky : Views of views of views

  Hello, to make a report easier I'm developing it using a view of joined views of joined views. Is there any significant performance penalty as opposed to just having one big select Cheers. I think there is because running a view on more than one table need more processing power than running a view n a single table. So if you are concerned about performance issues, you might certainly not run a view of joined views of joined views. Try the big select rather. Hope it Helps... ...Show All

• Brad Hehe SSIS with transaction

  Hi I new in SSIS. I tried to do the simple package with transaction support. I do the sql task wich "delete from TableName" and then i do a simple data flow from one table to "TableName" which i deleted from data before. I wanted to use transaction that in case the data flow collapse the transaction will roll back the delete task of table. But then i exucute my package it stucks like the table is locked. Can any one help me with this package Thanks. Are you using the package transaction option You could also do a SQL transaction, setting the RetainSameConnection property. SSIS Junkie : SSIS Nugget: RetainSameConnection property of the OLE DB Connection Man ...Show All

• globemast Blocking in Analysis Services

  We have a report in Reporting Services that connects to a Cube. The report has 4 input parameters that are also derived from the same cube. If the report is running and another user tries to select the drop downs for the report or runs just the query portion in report designer, the query will not return until the report has finished. It looks like the report is creating some type of wait. Has anyone ran across something like this You are in the wrong forum. Moving to Reporting Services forum first. ...Show All

• GeoffNin SQL Server Package Execution

  I tried to execute the package,which is importing the data from the Flat file(flat file from map network drive on other computer).But Packages are created and executed on Server.While i executing that package it shows error as "Package could not be found.". Please help me ASAP. Thanks in advance Is the package calling other packages When you execute the package look at the Connection Managers tab, and make sure the path to all of the child packages is correct. Whiz-kid wrote: I tried to execute the package,which is importing the data from the Flat file(flat file from map network drive on other computer).But Packages are created and executed on Serve ...Show All

• Keith Seifert Access DB2 on AS/400 using IBM OLE DB Provider

  Hi, I am using the IBM OLE DB Provider (IBMDASQL) provided with Client Access (IBM) to access a DB2 database on an AS/400 (iSeries). Using an OLE DB Source in the data flow and Access Mode set to "OpenRowset" this works fine (even though I think it is quite slow). However, when I change the Access Mode to "SQL Command" my data flow fails at the OLE DB Source component - not giving me any meaningful error description (only the mysterious "... the error is specific to the component..."). Using and SQL Command to access the data is important to me, since I need to put a WHERE-statement on the rows returned from the source. /Michael PS: I am not able to use the MS OLE DB Provider for DB2 (as far as I know it is only shipped with HIS ). ...Show All

• hrubesh Missing table in Datasource View dropdownlist of ProcessAdd config form of AS Process Task of SSIS

  I made 12 facttables and set them to the 12 partitions. the 12 facttables are the same, and I only build measures on facttable11. My first question is , will this be ok You know, when you build a measure group, it ask you to chose a facttable. I could not chose all the 12 facttables, right I only need to chose ANY one of the 12 tables,right If the answer is YES, could I chose diffrent tables for diffrent measure group and get the same result Nothing mentioned in MSDN. My second quesiton is, when I drop an AS Process TASK in SSIS, and chose to do a ProcessAdd on a partition, on the config form it ask me to chose a table or view that point to the partition i need to Process. On the Datasource View dropdownlist, If I chose the Datasou ...Show All

• Nobbie Unable to install SQl Server 2005 SP2 - Unexpected error

  I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files". O/s: Windows Server 2003 SP1 Product: SQL Server 2005 Standard Edition Log file shows: +++++++++++++++++++ === Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:\SQL2005sp2\hotfix.exe === MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0 MSI (c) (74:68) [16:05:42:635]: ******* RunEngine: ******* Product: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Cache\SQLSupport\x86\1033\SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI ...Show All

• Bulldog.NET SQL standard

  I just want to know which SQL Standard does the SQL Server & Oracle follows SQL-86 SQL-89 SQL-92 SQL1999 SQL-2003 Nitin-- does this is true for the both case, i mean, SQL Server as well as Oracle Additional :: Both SQL Server and Oracle do support parts of SQL-99 but neither of them supports the entire standard ... SQL-92 as far as i know both sql server and Oracle 9i Database support/comply to the ANSI SQL-92 , thoug these are just t ...Show All

• Barger problems executing a SELECT inside a TRAN against other computer

  Hi I have a problem executing a SELECT inside a TRAN against other computer For example: IN THE SQL Query Analizer of the COMPUTER2 1) this runs OK BEGIN TRAN SELECT * FROM COMPUTER2.DATABASE.DBO.TABLE COMMIT TRAN 2) this runs OK SELECT * FROM COMPUTER2.DATABASE.DBO.TABLE 3) this runs OK SELECT * FROM COMPUTER1.DATABASE.DBO.TABLE 4) this runs bad BEGIN TRAN SELECT * FROM COMPUTER1.DATABASE.DBO.TABLE COMMIT TRAN The problem is that TABLE locks and it does not finish. I've been looking for similar ERRORS in Microsoft Support but I found nothing I've uninstall and install de SQL server 2000 SP4 and the problems continues the same Please, someone could help me, thanks What do you mean when you say "this runs bad" D ...Show All