SP2 Calculated Member Issue

SQL Server Analysis Services

Index ‹ SQL Server

- Previous
  - 1
    - Help with modifying a data source's query at runtime Please help figure out what is wrong with my code. The script is supposed to load a package (from file). The loaded package already has everything set up to run a query against a local server and output the results to an Excel file. The reason for the outer script is because I need to change the query based on a global variable. When the query changes, though, I think the existing dataflow Path is no longer valid, so I should remove it and re-create another one with the new input mappings. Here is my code, which runs and throws an exception at the AcquireConnections call. The error is Error: 0x2 at Script Task: The script threw an exception: Exception from HRESULT: 0xC020801B I pieced together this code from the examples in the online books, but I am not sure what to do. ' Microsoft SQL Server Integration Services Script Task ' Write scripts using Microsoft Visual Basic ' The ScriptMain class is the entry point of the Script Task. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports Microsoft.SqlServer.Dts.Pipeline Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Public Class ScriptMain Public Sub Main() ' Dim app As Microsoft.SqlServer.Dts.Runtime.Application = New Application() Dim package As Microsoft.SqlServer.Dts.Runtime.Package = _ app.LoadPackage( "c:\systime\ExcelOut\ExcelOut\ExcelOutDo.dtsx" , Nothing ) Dim pkgVars As Variables = package.Variables Dim gsVar As Variable = pkgVars( "User::gsExcelFile" ) Dim currVars As Variables = Dts.Variables Console.WriteLine(Dts.Variables( "User::gsExcelFile" ).Value) gsVar.Value = Dts.Variables( "User::gsExcelFile" ).Value pkgVars( "User::gsQuery" ).Value = Dts.Variables( "User::gsQuery" ).Value pkgVars( "User::gsCreateTable" ).Value = Dts.Variables( "User::gsCreateTable" ).Value Dim e As Executable = package.Executables( "ExcelOutTask" ) Dim thMainPipe As Microsoft.SqlServer.Dts.Runtime.TaskHost = _ CType (e, Microsoft.SqlServer.Dts.Runtime.TaskHost) Dim dataFlowTask As MainPipe = CType (thMainPipe.InnerObject, MainPipe) ' Get the source component. Dim SourceComponent As IDTSComponentMetaData90 = _ dataFlowTask.ComponentMetaDataCollection( "Local Source" ) Dim srcDesignTime As CManagedComponentWrapper = SourceComponent.Instantiate() srcDesignTime.ProvideComponentProperties() ' Reinitialize the metadata. srcDesignTime.AcquireConnections(vbNull) srcDesignTime.ReinitializeMetaData() srcDesignTime.ReleaseConnections() ' Get the destination component. Dim destination As IDTSComponentMetaData90 = _ dataFlowTask.ComponentMetaDataCollection( "Excel Destination" ) Dim destDesignTime As CManagedComponentWrapper = destination.Instantiate() destDesignTime.ProvideComponentProperties() ' Create the path. dataFlowTask.PathCollection.RemoveAll() Dim path As IDTSPath90 = dataFlowTask.PathCollection.New() path.AttachPathAndPropagateNotifications(SourceComponent.OutputCollection(0), _ destination.InputCollection(0)) 'Console.WriteLine(dataFlowTask.PathCollection.Count) Dim ret As DTSExecResult ret = package.Execute() Console.WriteLine(ret.ToString) Dts.TaskResult = Dts.Results.Success End Sub End Class Tag: SP2 Calculated Member Issue
  - 2
    - Two Dimensions Sharing same Parent Table Hi, I have a serious problem when I explore my Dw Model. I have one Fact table and Two Dimensions: Brand Dimension and Department Dimension. Both Dimensions share at Top Level Company Attribute. The Schema is like this : Brand Dimension : Brand (Brand Table), Brand Group(Brand Group Table), Company (Company Table) Department Dimension : Department( Department Table), Department Group(Department Group Table), Company (Company Table) Almost forgot..The Company attribute is present on all tables because is a key member. At this point everything was ok. But when I started to explore on AS (Browser) my problems has just started. I realize that, for AS, the Company attribute is not the same for both Dimensions. When I filtered by Company from Department Dimension I saw all Companies from Brand Dimension. Naturally I wish to see the same Companies only. Any clues Thanks a lot Joao Tag: SP2 Calculated Member Issue
  - 3
    - Can't shrink DB Hi, The DB size (MDF) is getting too big, sp_spaceused returns: reserved data index unused 1418656 KB 250168 KB 1408 KB 1167080 KB I've tried both SHRINKFILE and SHRINKDATABASE with all types of options. The DB designed on SQL 2000 and ported to SQL 2005 EXPRESS, I've laso used DBCC UPDATEUSAGE. Any ideas Thanks, YP Tag: SP2 Calculated Member Issue
  - 4
    - Reporting services in SharePoint integration mode problems Hi, I'm having problems setting up Reporting Services in SharePoint Integration mode. The development environment works fine, but I can't get it to work in production. Problem seems to be in the authentication between SharePoint and Reporting Services. When I go to "Set Server Defaults" in the SharePoint central administration I get the following message: Code Snippet An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2006.ReportingService2006.ListSecureMethods() at Microsoft.ReportingServices.SharePoint.Soap.ReportService2006.ListSecureMethods() --- End of inner exception stack trace --- I get the same message when trying to deploy a report from Visual Studio to a SharePoint lib. Some info: - SP apppool is running under domain account a - SSRS apppool is running under domain account b - SP uses NTLM authentication - SP and SSRS are running on different servers - SSRS Configuration shows all green checkmarks Things I tried: - Basic authentication instead of Windows Integrated on SSRS - NTLM only instead of Negotiate on SSRS - Settings SPN's for SSRS, didn't help - Checked NTFS rights on ReportingServer dir, were fine (Domain users have read/list) Does anyone have an idea about how to solve this Any help is appreciated. Tag: SP2 Calculated Member Issue
  - 5
    - Recursive Query Without Self-Referencing Structure I need a statement that can return a hierarchy of folders. There are a number of good articles out there describing how to do this in SQL 2005 with a Common Table Expression (CTE) that references itself under a UNION ALL. Yet every example I come across involves a self-referencing table. Unfortunately the architect of my project did not use that simple structure. Instead, we have a Folder table and Folder Properties table. Creating a child Folder involves adding a row in the Properties table that links to a parent. Here's the statement I came up with: WITH Folders (ID, ParentID, FolderName, FolderDepth) AS ( SELECT FOLDER_ID, NULL, FOLDER_NAME, 0 FROM ZZ_FOLDER WHERE FOLDER_ID = 1 UNION ALL SELECT F.FOLDER_ID, Folders.ID, F.FOLDER_NAME, Folders.FolderDepth + 1 FROM ZZ_FOLDER F INNER JOIN ZZ_FOLDER_PROP FP ON FP.FPROP_FOLDER_ID = F.FOLDER_ID WHERE FP.FPROP_LINK_ID = Folders.ID ) SELECT * FROM Folders The initial statement brings back the top of the folder structure. The recursive statement brings back Folder rows that have an entry in their Property rows for the parent. Yet when I try to execute this, I get: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.ID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Folders.FolderDepth" could not be bound. It sounds like all the recursive references to the CTE are unavailable. What am I doing wrong Would welcome any suggestions, too. I realize this isn't a T-SQL specific question, more SQL in general, but I didn't see a more relevant forum. What follows are some tables/data to run the above statement against. -- Create Folder Tables CREATE TABLE ZZ_FOLDER ( FOLDER_ID INTEGER NOT NULL PRIMARY KEY, FOLDER_NAME VARCHAR(50)) CREATE TABLE ZZ_FOLDER_PROP ( FPROP_ID INTEGER NOT NULL PRIMARY KEY, FPROP_FOLDER_ID INTEGER NOT NULL, FPROP_LINK_TYPE VARCHAR(50), FPROP_LINK_ID INTEGER NOT NULL) GO -- Populate Folder Tables INSERT INTO ZZ_FOLDER VALUES (1, 'Top Level') INSERT INTO ZZ_FOLDER VALUES (2, 'Second Level A') INSERT INTO ZZ_FOLDER VALUES (3, 'Second Level B') INSERT INTO ZZ_FOLDER VALUES (4, 'Second Level C') INSERT INTO ZZ_FOLDER VALUES (5, 'Third Level A1') INSERT INTO ZZ_FOLDER VALUES (6, 'Third Level A2') INSERT INTO ZZ_FOLDER VALUES (7, 'Third Level A3') INSERT INTO ZZ_FOLDER VALUES (8, 'Third Level B1') INSERT INTO ZZ_FOLDER VALUES (9, 'Third Level C1') INSERT INTO ZZ_FOLDER VALUES (10, 'Third Level C2') INSERT INTO ZZ_FOLDER VALUES (11, 'Fourth Level A3A') INSERT INTO ZZ_FOLDER_PROP VALUES (1, 2, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (2, 3, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (3, 4, 'Folder', 1) INSERT INTO ZZ_FOLDER_PROP VALUES (4, 5, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (5, 6, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (6, 7, 'Folder', 2) INSERT INTO ZZ_FOLDER_PROP VALUES (7, 8, 'Folder', 3) INSERT INTO ZZ_FOLDER_PROP VALUES (8, 9, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (9, 10, 'Folder', 4) INSERT INTO ZZ_FOLDER_PROP VALUES (10, 11, 'Folder', 7) GO /* Top Level Second Level A Third Level A1 Third Level A2 Third Level A3 Fourth Level A3A Second Level B Third Level B1 Second Level C Third Level C1 Third Level C2 */ Tag: SP2 Calculated Member Issue
  - 6
    - c# reusing parameters I have a select statement which requires numerous parameters. here is a snippet. SqlCommand cmd = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2 AND Answer3 = @Att3", connection) my parameters are added as follows. SqlParameter Att1 = new SqlParameter("@Att1", SqlDbType.VarChar, 50); Att1.Value = Attributes1; cmd.Parameters.Add(Att1); and so on... What I would like to do is be able to remove a parameter and re-run the SELECT statement if the number of entries retrieved is less than 5 (or any number) I tried just having a new Sql command like this. SqlCommand cmd2 = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2, connection) and then did this.. cmd2.Parameters.Add(Att1); but it didn't work. Is there a way to do this so I don't have to keep copying the whole parameter command Thank you in advance for your help. And please be gentle, I'm very new to this. Tag: SP2 Calculated Member Issue
  - 7
    - allocation problem/disk space disappears when processing cube Preston M. Price wrote: I get this error while processing my cubes: Error: Memory error: Allocation failure : Not enough storage is available to process this command. There is plenty of space left on the hard disks on this machine, I can't find a remedy for this problem on Google either. Any help would be appreciated. Thanks in advance. I am seeing the same disk space issue as described in original post. Each partition is about 8GB, total 14 partitions. each partition about 50M rows. The cube was processed before so it exists with about 110GB total used space. Free space about 200GB. When re-processing the same cube, the free space seems to slowly disappear, for example only after processing 2 partitions, the free space went from 200GB to 40GB. This is while the total used space in this cube directory is 120GB. The used space makes sense - 110GB + 8G for 2nd copy of partition that's being processed. The free space gone to neverland is what doesn't make sense! I am processing partitions from BIDS (highlighted all partitions). Processing each partition separately, each with its own transaction. I've seen the same type of Disk space stealing by SSAS server when for example deleting a cube. Somehow when I delete the cube, it does not show that disk space is free, while the files are gone!, - that is until you restart SSAS server. can anyone shed a light on this (win 2003 ent, sql 2005 ent sp2 fin, 32 bit, 16gb ram, 4 cpu) Does SSAS actually use the Disk for temporary cache of data during aggregation can anyone from MS SSAS team clarify if that's true, which "directory" is it, and can I change it to be a different disk I so happen to have more free space available on a different drive (not OLAP Data drive). any ideas Tag: SP2 Calculated Member Issue
  - 8
    - searching a Unicode data within a Image data type How to Searching a unicode data if we have Image Data Type within our SQL Server 2000. Hi, I have the problem with to finding a data from Image Data type using Full Text Catalog if i have some unicode data to find. so tell me solution to applying a Full Text Catalog to Image Data type which contains some Unicode value. waiting for your response soon. i have to find some "Hindi Text" which stored in Image data type and have to find using SQL full text catalog. Please help me in this manner..... Tag: SP2 Calculated Member Issue
  - 9
    - SQL 2005 32-bit vs 64-bit guidance What some good reasons to select 64-bit rather than 32-bit for SQL Server 2005 We are preparing to install a very large SQL Server 2005 cluster. Initially, the primary database is estimated at 1 Terabyte, with 5 more databases that will add up to another Terabyte. After a few years, the estimate jumps up to 20 Terabytes for the largest DB and another 20 for the other five, combined. We've made the assumption that a database this large, with up to 1000 concurrent users, that this is a good candidate for a 64-bit installation. And that we're better off starting out with 64-bit, rather than migrating later. Can someone provide some guidance Tag: SP2 Calculated Member Issue
  - 10
    - Setting a filter in the SELECT-statement Is it possible to set a filter in the SELECT-statementpart Normaly you the filter is set in the WHERE-statementpart, but that is too late for me in my statement. Right after the SELECTing the field I want to set a filter to the query Is it possible My statement looks like this now: SELECT [DatabaseName$Item].No_, [DatabaseName$Item].Description, [DatabaseName$Sales Price HAG].[Unit Price], [DatabaseName$Sales Price HAG].[Starting Date], [DatabaseName$Sales Price HAG].[Starting Time], [DatabaseName$Sales Price HAG].[Sales Code] (<== here on this item I want to set a filter) FROM [DatabaseName$Item] INNER JOIN [DatabaseName$Sales Price HAG] ON [DatabaseName$Item].No_ = [DatabaseName$Sales Price HAG].[Item No_] INNER JOIN (SELECT [Item No_], MAX([Starting Date]) AS MaxStartingDate, MAX([Starting Time]) AS MaxStartingTime FROM [DatabaseName$Sales Price HAG] AS [DatabaseName$Sales Price HAG_1] GROUP BY [Item No_]) AS SubQuery1 ON [DatabaseName$Sales Price HAG].[Item No_] = SubQuery1.[Item No_] AND [DatabaseName$Sales Price HAG].[Starting Date] = SubQuery1.MaxStartingDate AND [DatabaseName$Sales Price HAG].[Starting Time] = SubQuery1.MaxStartingTime Thx for helping! Tag: SP2 Calculated Member Issue
  - 11
    - ADO Error: an insufficient number of arguments.... Im currently using Access 2000 which is connected to a SQL database. I have a query (Or View) that runs every month. The problem i had was i had to manually make some changes every month to get to the data i needed so i changed this View into a Function with a parameter so i can input the detail(s) i need and it will run correctly - this works so far but the original View was also used within other queries that were created. Now the problem i have now is some of the other views that are now connected with the newly created Function comes up with the error: ADO error: an insufficient number of arguments were supplied for the procedure or function Name_Of_Function. I called the newly created function the exact name as the original view to ensure i had no problems. Any idea of whats happening here and how to resolve Thanks Tag: SP2 Calculated Member Issue
  - 12
    - Installing SQL Server 2000 SP3a I got this mess ag e from Backup Exec for Windows Servers Environment Check 1.0 for SBS1 QUOTE An instance of Microsoft SQL 2000 was found that is not updated to Service Pack 3a. An instance of Microsoft SQL Server was found that is not updated to the correct service pack. Using this SQL Server instance with Backup Exec may cause errors. To install Backup Exec successfully, upgrade this SQL Server to Service Pack 3a, or select another instance. Instance: SBSMONITORING, Version: 2000 SP 3a Instance: SHAREPOINT, Version: 2000 SP 3a Instance: BKUPEXEC, Version: 2000 SP 3a Instance: PADMINISTRATOR, Version: 2000 SP 3a Instance: MICROSOFT##SSEE, Version: 2000 UNQUOTE My Question is how to upgrade the instance : "MICROSOFT##SSEE, Version: 2000" to SP 3a Tag: SP2 Calculated Member Issue
  - 13
    - Bookmark in Code not working. I have a report in reporting services that has a bookmark value asigned to each row. In the following Page_Load event for the page, I'm getting the following error on the ReportViewer1.JumpToBookmark("6") statement: "An exception of type 'System.InvalidOperationException' occurred in Microsoft.ReportViewer.WebForms.dll but was not handled in user code Additional information: Some parameters or credentials have not been specified" Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Dim strReport1 As String = "/ReportDirectory/CurrentWeekSales" ReportViewer1.ServerReport.ReportServerU rl = New System.Uri(CStr(Session.Item("ReportServ er"))) ReportViewer1.ServerReport.ReportPath = strReport1 ReportViewer1.ServerReport.Timeout = 500000 Do While ReportViewer1.ServerReport.IsDrillthroug hReport ReportViewer1.PerformBack() Loop Dim RptParameters1 As ReportParameter() = New ReportParameter(0) {} RptParameters1(0) = New ReportParameter("EBO_EmpKey", CStr(Session.Item("UserKey"))) ReportViewer1.ServerReport.SetParameters (RptParame ters1) ReportViewer1.ServerReport.Refresh() ReportViewer1.JumpToBookmark("6") End If End Sub What am I missing Thanks Tag: SP2 Calculated Member Issue
  - 14
    - Slow Running Insert After Changing OLE DB Destination Data Access Mode Hello, In a Data Flow Task, I have an insert that occurs into a SQL Server 2000 table from a fixed width flat file. The SQL Server table that the data goes into is accessed through an OLE DB connection manager that uses the Native OLE DB\Microsoft OLE DB Provider for SQL Server. In the OLE DB Destination, I changed the access mode from Table or View - fast load to Table or View because I needed to implement OLE DB Destination Error Output. The Error output goes to a SQL Server 2000 table that uses the same connection manager. The OLE DB Destination Editor Error Output 'Error' option is configured to 'Redirect' the row. 'Set this value to selected cells' is set to 'Fail component'. Was changing the access mode the simple reason why the insert from the flat file takes so much longer, or could there be other problems Thank you for your help! cdun2 Tag: SP2 Calculated Member Issue
  - 15
    - SQL Server Assertion ERROR We have a browser based application that is doing some updates on the database. This app was earlier built to run on SQL server 2000 and we are in the process of migrating to SQL server 2005. Until now the application was seamlessly working on the new SQL server 2005 database. I got the following error message on the web when an item was clicked on the web that triggered a set of database updated through our app server. This is first time i am seeing anything like this. --------------------------- Windows Internet Explorer --------------------------- Unable to delete the selected items. Warning: Fatal error 3624 occurred at Feb 5 2007 2:34PM. Note the error and time, and contact your system administrator. A severe error occurred on the current command. The results, if any, should be discarded. Location: IndexRowScanner.cpp:370 Expression: m_sizeOfBuffer > currentOffset + colLen SPID: 54 Process ID: 2712 --------------------------- OK --------------------------- In the beginnning we thought it may be some thing in the app server or the CLR. But when I checked the process ID in the task manager it turned out to be SQL server 2005 process. the SPID was the application servers connection to the database. This is what I got when i ran the profiler. SQL Server Assertion: File: <IndexRowScanner.cpp>, line=370 Failed Assertion = 'm_sizeOfBuffer > currentOffset + colLen'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted. Warning: Fatal error 3624 occurred at Feb 5 2007 3:00PM. Note the error and time, and contact your system administrator. 2007-02-05 15:00:23.04 spid54 Error: 3624, Severity: 20, State: 1. 2007-02-05 15:00:23.04 spid54 A system assertion check has failed. Check the SQL Server error log for details Any clues on what this is all about Thanks.. Tag: SP2 Calculated Member Issue
  - 16
    - Management Studio -> Could Not Find Function xp_msver in library xplog70.dll Hello, When I click into Microsoft SQL Server Management Studio Express and login with windows auth and right click the top of tree, the acutal SQL server instance name, and click properties I get the following error. http://www.ftoperations.net/screen_shot.jpg Any ideas what is causing this Everything else works perfect in Studio Express, and am able to view tables, stored procedures, generate reports, everything except get the properties of the SQL instance. Thanks for the help. Tag: SP2 Calculated Member Issue
- Next
  - 1
    - about database and table protect hello, We wrote an erp,and provide a platform to participator to extend my erp system,so I will give my participator database dictionary,but I only want to give partial database dictionary,I will hide some table and some field, I want they cann't open the database thouth sql server management studio or other tools,only can using our interface to access database,how can I do -- I use sql server 2005 Tag: SP2 Calculated Member Issue
  - 2
    - Database Mirroring. Asp application (IIS 6.0) does't forward connections to mirror server Hi! I have setup a database mirroring session without witness - ServerA is the principal, ServerB is the mirror,. Each SQL Server instance is hosted on its own machine on sql2005 EE SP2. The mirroring is working correctly. If I submit to server ServerA command: ALTER DATABASE MYDBNAME SET PARTNER FAILOVER , ServerB becomes the principal, it means that mirroring works correctly. My issue is with the SQL Native Client and a front-end ASP application (actually IIS 6.0 site) that needs to make use of this database. I have setup my front-end application to use SQL Native Client and specified the failover server in connection string. Here is the connection string that I am using : PROVIDER=SQLNCLI.1;Server=ServerA,1433;Failover Partner=ServerB,1433;Database=MYDBNAME;Network=dbmssocn;Integrated Security=SSPI; Everything works perfectly on my front-end application when ServerA is the principal. If I execute on server ServerA command: ALTER DATABASE MYDBNAME SET PARTNER FAILOVER , ServerB becomes the principal, and the failover occurs correctly on the database side. The problem is that my front-end application is not able to query the database on ServerB. The error appears: Microsoft SQL Native Client error '80004005' Cannot open database "MYDBNAME" requested by the login. The login failed. This behavior my appication till I unload IIS 6.0 pool application. After that my front-end application becomes work correctly with ServerB. When I swap server, I execute on server ServerB command: ALTER DATABASE MYDBNAME SET PARTNER FAILOVER, my IIS 6.0 application automaticly turn back to ServerA without any action on my side. I am using SQL Native Client last version http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlncli.msi (issued in February 2007). Has anyone experienced this issue I'm thinking that it's a problem in the SQL Native client Tag: SP2 Calculated Member Issue
  - 3
    - SQL2005 C# connection problem When attempting to connect to a SQL2005 database using Visual C# Express edition I receive the following message: The user instance login flag is not supported on this version of SQL Server. I do not have this problem when using SQLExpress Tag: SP2 Calculated Member Issue
  - 4
    - how to design queries graphically? Are there anytool, which would allow me to design queries graphically, if not design then atlease analyse them graphically. Tool should atleast show join of 4tables graphically. Thank You. Tag: SP2 Calculated Member Issue
  - 5
    - ASP: error when trying to insert record I receive the following error when trying to INSERT INTO; am using Access db. Microsoft OLE DB Provider for ODBC Drivers error '80040e07'[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The code is as follows: <% Dim dbConn set dbConn = server.CreateObject("adodb.connection") dbConn.open("connect") dbConn.Execute("INSERT INTO tbl_country (region, countryName, population, country_currency, description, imageURL, imageALT) VALUES ('" & Request.Form("region") & "', '" & Request.Form("countryName") & "', '" & Request.Form("population") & "', '" & Request.Form("country_currency") & "', '" & Request.Form("description") & "', '" & Request.Form("imageURL") & "', '" & Request.Form("imageALT") & "'),") Response.Redirect("admin_master.asp") %> I would greatly appreciate any help you can give me. Tag: SP2 Calculated Member Issue
  - 6
    - insert into exec distributedprocname There must be some workaround for this. I need to grab the data from a stored proc on another server and place it into a temp table. I do not have the option to change the proc. help if you can. Tag: SP2 Calculated Member Issue
  - 7
    - how to use variable to create index Hi , I would like to create index for a table and that index name must be random generated. How to do this declare @value varchar ( 50 ) set @value = rand () set @value = @value + 'index-name' create index @value on tablename(variables) Tag: SP2 Calculated Member Issue
  - 8
    - SQL CE 3.1 Why is there no option for a char vs nchar data type The app I'm building has char based data, not nchar. My SDF database is twice as large and twice as slow as it needs to be. Tag: SP2 Calculated Member Issue
  - 9
    - Disk activity We are about to go to SQL 2005 and that means getting some new Servers and i am wondering if our SAN is adequate. I like to measure over the next few weeks the amount of data that is sent to the SAN and how long its taking to come back....i.e if someone is running a large report how much data is sent and how long it takes to return. This is for 2000 SQL (i like to get all these results to build my migration plan and hardware configuration). I like to see...........18 mb of data , date time and how much read / write etc if possible the sql. Any ideas Tag: SP2 Calculated Member Issue
  - 10
    - Check the finish time of data driven subscription using Sql How can I check using sql that a data driven subscription has run and the time it had finished Thanks Elias Tag: SP2 Calculated Member Issue
  - 11
    - create a "Yesterday", "This Week", "Last Week" calculated member Hi all, I'd like to add a yesterday dimension member to a new dimension, like a "Time Utility" dimension, that references the second last day of non empty data in a cube. At the moment, I'm doing this: Code Snippet create member [MIA DW].[DATE TIME].[Date].[Yesterday] as [DATE TIME].[Date].&[2007-01-01T00:00:00] select [Measures].members on 0, non empty [DATE TIME].[Date].members on 1 from [MIA DW] But the [yesterday] member does not seem to belong to [DATE TIME].[Date].members So I guess there's two questions: 1) Can I have a new empty dimension which contains all these special members like "Yesterday" or "This Week" and "Last Week" (these last two obviously refer to a set of Dates) 2)How come the Yesterday member is not returned by the .members function Thanks Greg Tag: SP2 Calculated Member Issue
  - 12
    - Cluster Query Hi All, I am deciding on high-availibitly for my database server box. My website can get large number of user hits for 4 days in every quater of year. We are also planning to launch some schemes which will help keep are business and servers busy . I am planning to have 2 node cluster. With configuration Windows Server 2003 Standard Edition 64 bit SQL Server 2005 Standard Edition 64 bit 4 GB RAM 8 x 300 GB Ultra 320 SCSI Hard Drives Hardware RAID 0+1 Redundant Controllers Fiber Attached My Question are. 1) What type of clustering I should go for (Active/active vs Active/Clustering) and why 2) Will active/active means load balancing as there will be 2 servers as active and both of them can share the load 3) What are the advantages and disadvantages of clustering type you recommend in question 1. 4) We are also planning to configure transactional replication on these servers as per disaster recovery plan. Will it an overhead to the servers if they are in different geographical locations (My network bandwidth is 100 mbps connection) Please help. Thanks in advance. regards S Tag: SP2 Calculated Member Issue
  - 13
    - Dealing with two databases Hello, Question 1: In my senario i've developed a system which utilizes 2 database, i've writen queries like db1.dbo.table1 join db2.dbo.table2 etc... Now that db2 is getting huge, client wants to shift it to another server. I don't know how to modifiy my queries to cope with such situation. Could somebody plz tell me on how to you write queries involving two databases from different servers. Question 2: I'm maintaining second database (db2) to keep track of records of db1 which have been processed by my software, so that when db1 gets added with more records i can compare db2 table with db1 table to identify which records are new. db1 is not my database and i don't have any control over that, (it's some erp db), is there any way of identifying which rows have been processed. Can the need for db2 be eliminated I'm using SQL Server 2005 Thank You, Sandeep. Tag: SP2 Calculated Member Issue
  - 14
    - Unable to connect remotelly to mdf.life on sql server 2005 express edition I have a c# application running on my machine. I want to point to a sql server data base express edition running on other machine. By default, from server explorer Ionly acces data base files of the local machine. I dont have acces to remote servers. I used the file explorer and opened the mdf file on remote server. I tried to acces the mdf file remotely but i got excepcion. My questios are: - Is sql server 2005 express edition supporting remote connection to mdf data base file - In other words, I can remotelty conncect to mdf file from remote machine So, I how can point my application to remote sql server 2005 express edition data base running on other machine Please, Help Tag: SP2 Calculated Member Issue
  - 15
    - same value for different parameter values I have a problem with reports parameters. When I enter the parameter value , Report shows the same value no matter what the parameter value is. Here is my code. Code Block WITH yesterdayCTE AS ( SELECT type = 'Members Joined Yesterday' , Borrowers = (select count(*) from LoanApplication where LoanApplication.SubmittedOn >= GETDATE()-1) , Depositors = (select count(*) from CDOrder where CDOrder.SubmittedOn >= GETDATE()-1) , CreditUnion = ( select CreditUnion.Name from CreditUnion where (CreditUnion.Id = @CreditUnionID) ) ), last7daysCTE AS ( SELECT type = 'Members Joined Last 7 Days' , Borrowers = (select count(*) from LoanApplication where LoanApplication.SubmittedOn >= GETDATE()-7) , Depositors = (select count(*) from CDOrder where CDOrder.SubmittedOn >= GETDATE()-7) , CreditUnion = ( select CreditUnion.Name from CreditUnion where (CreditUnion.Id = @CreditUnionID) ) ), last30daysCTE AS ( SELECT type = 'Members Joined Last 30 Days' , Borrowers = (select count(*) from LoanApplication where LoanApplication.SubmittedOn >= GETDATE()-30) , Depositors = (select count(*) from CDOrder where CDOrder.SubmittedOn >= GETDATE()-30) , CreditUnion = ( select CreditUnion.Name from CreditUnion where (CreditUnion.Id = @CreditUnionID) ) ), combinedCTE AS ( SELECT * FROM yesterdayCTE UNION ALL SELECT * FROM last7daysCTE UNION ALL SELECT * FROM last30daysCTE ) SELECT * , Members = Borrowers + Depositors FROM combinedC Can anyone tell me how to fix this Thanks Tag: SP2 Calculated Member Issue
  - 16
    - What is wrong with my codes to connect VB.net to sql server 2005 Express database? Hi am very new with VB.net (Visual Studio 2005) and the first time try to use the sql server 2005 express. I did create a trial.mdf (local server) and complete procedure to attach the trial1.mdf in Microsoft SQL Management Studio Express. I try to use VB to connect /open/close it with the following codes: (but failed) ----------------------------------------------- Imports System.Data.SqlClient Public Class Form1 'Link database Dim DB_Location = " c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Trial1.mdf " Dim MyConnection = "Server=localhost; DataBase= " & DB_Location & "Integrated Security =SSPI" Dim sqlConnection As New SqlConnection(MyConnection) 'Use database Dim strSQL As String = "SELECT FROM Trial1 WHERE col2 = 'trial' " Dim cmd As New SqlCommand(strSQL, MyConnection) sqlConnection.Open() ' ----> error cmd.ExecuteNonQuery() ' ----> error sqlConnection.Close() ' ----> error End Class ------------------------------------------- At the last 3 line of codes I got the errors ... can someone explain why & help me to correct it Thanks for any help Tag: SP2 Calculated Member Issue

BobP - BIM

I have had this calculated Member for over a year, when I applied SP2, I am returned an error.

I have looked on MSDN for something that would indicate what the change was, but cannot find it.

Here is the MDX:

Case

When IsEmpty( [Measures].[Loan Amount] )

Then 0

Else ( [Product].[All] * [Channel].[All] * [Date Closing Funded].[All] * [Loan Status].[Status Rollup].&[Closed]* [Date Closing Funded].[MonthName].CurrentMember, [Measures].[Loan Amount])

End

Again, this has been working for over a year.

Any help would be greatly appreciated!

BobP

Top

Re: SP2 Calculated Member Issue

Jeffrey Wang

The expression in your else branch doesn't look right. The subexpression using *'s can only be a set if the * is interpretted as crossjoin or a scalar if the * is interpretted as multiplication. In either case the else branch cannot be a valid tuple expression.

Do you actually mean to have the following

( [Product].[All], [Channel].[All], [Date Closing Funded].[All], [Loan Status].[Status Rollup].&[Closed], [Date Closing Funded].[MonthName].CurrentMember, [Measures].[Loan Amount])

Top