Answer Questions

• pavvu_kk Semiadditive

  Hi, I'm attempting to set up a measure with semiadditive property of LastNotEmpty. This works fine along the time dimension - except it is also using LastNotEmpty along the other (non time) dimensions. Is this working the way it is intended - or do I need to set up dimensions / measures a different way Hi Mosha, Thanks for the note - yes you are correct - I had not set up the time dimension correctly, I've fixed that & now it is aggregating correctly. regards I think you are mistaked. LastNonEmpty only does Last non empty along Time, and Sum along all other dimensions. Please provide the queries and their results to show the anomaly you experience. ...Show All

• M.D.A Insidious Bug?

  This looks like a bug to me, can someone verify that this is faulty behavior or tell me why it is proper Two stored procedures are defined, each creates a temporary table of the same name, but with different definitions. Both procedures compile successfully. If procedure Two is executed by itself, errors are produced. Once procedure One has been run, then both procedures succeed. It seems to be an issue of improperly resolving the definition of the temporary table. Thanks drop procedure one go create procedure one as begin create table #salt( a int not null, b int not null, c varchar(100) ) insert #salt values( 1, 1, 'Fred' ) insert #salt values( 1, 2, 'Barney' ) insert #salt values( 1, 3, 'Wilma' ) ...Show All

• monolith1986 Microsoft report builder is a very BAD product

  This product can't make a report selectin measures from more then on cube at the same time crossed by to shared dimensions, it's a shame. Please don't say you have a web base ad-hoc query if you can’t even do same basic stuff like this. Please do the test with adventures works , and open the browser and choose report builder, you will see that you can't do a report choosing a measure from two diferente measures groups and by more then one dimension. I can do what I want in visual studio I have no problem there buillding my owne query and customize the sql ou mdx. The problem is that the end users can't, the end users use report builder and this t ...Show All

• Vaish Dropdown parameter in Report Builder

  Hi, Is it possible to create a dropdown parameter in Report Builder The result I want to get is (for example): The parameter is "Project". Next to the parameter should be a dropdown box from where I can select a project (for example: project1, project2, ...). Once the parameter is selected, and I click "view report", the report should only display data from the selected project. The only other options available in the Filter dialog screen are: "Field" is in list "Field" contains "Field" equals But none of these methods of creating a parameter generate a dropdownbox from where items can be selected, equal to those in the database. So ... is it even possible to create a dropdown p ...Show All

• Tanzir populate Fulltext Perfomance issue

  I am in the final stages of testing 2005 for our upgrade path... I have 4 catalogs: 3 are attached to large tables but the columns that are indexed are small (varchar(500) or less)... These catalogs had an increase in population speed decreasing the time of population by 20-40% which we are very happy about. However, the 4th table has many columns indexed 4 of which are varchar(max)... This table seen a decrease by such a magnitude that it is causing concern. It went from taking about 90 minutes with update index in background set or 35 minutes with that option not set to 13 hours.... I don't see an option for updating index in background. During the population it seems to be hogging the CPU a lot. The server still performed fine but ...Show All

• Peter Cwik Is there a way to have numbers listed against each rows

  I want to return numbers 1,2,3... for each row  in my reports when its returned e.g I want my report to have numbers listed against each row 1. boy 2. cat I looked at the Globals but i can't see anything to use.. Any ideas Sure it must be easy.. Thanks in Advance try this =RowNumber(Nothing) Moze tak :) Nie jestem Polakiem jestem z Nigerii ale tam studiowalem i mieszkalem Swiat jest maly:) Patrick RowNumber takes a scope parameter so you can number within a group. I'm not sure if you can get row numbers to ignore grouping, I think not. Maciek, Dzieki stary pozd Patrick Thanks for the reply. But =RowNumb ...Show All

• Dorfer matrix column grouping

  Hi, I have a requirement from my users to be able to drill down for a single column in a matrix. I've been able to implement drilldown for all of the measures (all columns grouped at the same time) in my matrix but they now want to be able to group different columns independently of each other. In other words they want to be able to group the data in different columns by different things. An example might make my question clearer, the report would need to look like this:  Client Name Sales - Costs + Revenue - Client A + Europe + Middle East + Asia Pacific + $12,000,000 Products + Investments + $12,000,000 $8,000,000 $4,000,000 $10,000,000 $22,000,000 ...Show All

• dana_lotus 0x80131500 Error while trying to read an XML Source

  Hi, This is my first time trying to import data from an XML file. It seems wonderfully straightforward. I currently have my Data Flow set up correctly. However, when I try to run my package I get a series of errors. One error is a 0x80131500 which is a very generic error. It say's it's haveing a hard time with a 'Url' field in the XML. The size of the field is set to 255 which should take care of any issues with Truncating. The only issue that I can see with that field is that it contains a query string which of course contains a special '&' XML character (&). When I set the Error Handling to Ignore that Error on that column, it imports just fine, however, NONE of the URL's get inserted.  So there must be a problem with e ...Show All

• Tadwick Subscript font style in a text box?

  Seems like a long shot, but I'd really like to show "CO2" (chemical formula for carbon dioxide) with the "2" as a subscript, in a report text box. The "CO2" would be embedded as part of a sentence, e.g. "The CO2 emissions..." Is there any way to do this Eva Pierce Monsen If you haven't already found a solution. Please try following: Use one of the following fonts only for your text box: 1. Lucida Sans Unicode 2. Palatino Linotype Then use the standard unicodes with the chrw function as mentioned above in one of the replies. e.g. for superscript 4, use chrw(8308), Export to pdf and you should be good. HS ...Show All

• Mark Challen Leaf level calculations

  Need to calculate datediff([base measure date], [user selected Time dimension level's end date]) for each leaf-level member. e.g. datediff([base measure], [selected Year's end date]) Year End Date is an attribute of the Time dimension Cannot have this multiplication in the dsv named query since user's selection is not known then. Member expressions can only have the form measure1*measure2 or measure1/measure2 In the calculations script scope(base measure) scope(leaves()) scope(base measure) this = datediff("d", base measure, CurrentTimeMember.Properties("end date")) end scope..... does not work since CurrentTimeMember in this context becomes Date, whereas selected Year is required and its end date for t ...Show All

• wls1973 Restoring to a new DB - The basics

  Hiya, I've recently gotten into the administration side of SQL and am muddling my way through it as best I can. We have a DB server with three or four databases on it. Maintenance routines do a full backup of each one nightly and weekly and put all sets into one backup (.bak) file. I've never had to restore them, but I thought I'd put myself through a test run since this is unexplored territory for me and I would prefer not to have to learn in an emergency. A scenario I can foresee is where I'd have to restore just one table, perhaps to a new location (i.e. not overwrite the live db, just bring up a copy of part of it elsewhere so I can do a data dump from some old data). But when I go to 'restore database' or 'restore file/filegr ...Show All

• noel 55 Incorrect syntax near 'nvarchar'

  When I try to insert data in sql server 2000 database with a formview. I got this error: Line 1: Incorrect syntax near 'nvarchar'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'nvarchar'. The insert statement is right and works manuallly. INSERT INTO REUNIOES(DATA_P1, DATA_P2, [MIG/SIR], FRENTE, LIDER, ATIVIDADE, DATA_PLANEJADO, DATA_CONCLUSAO, DATA_REPLANEJAMENTO, STATUS, EQUIPE) VALUES (@DATA_P1, @DATA_P2, @MIG, @FRENTE, @LIDER, @ATIVIDADE, @DATA_PLANEJADO, @DATA_CONCLUSAO, @DATA_REPL ...Show All

• vectorg Upgrade from SQL 2005 Developer Edition to SQL 2005 Standard Edition (all 64 Bit)

  I have a problem, because we installed the SQL Server 2005-64Bit Developer Edition on a 2003 Server R2-64Bit with 10GB RAM an 2 Xeon. Now we have huge performance problems wich should be better using the Stadard Edition... I don't know if it is easily possible to upgrade by only inserting the DVD and start the Setup... Has anybody some experiences Please give some information.... Yes, that includes 32 bit Developer to 32 bit Standard. You can verify here . Does this apply to 32-bit, as well Is there documentation I just realized I used the wrong stupid disk on a production install... Yes, this upgrade path SQL Server 2005-64Bit Developer Edition to SQL Server 2005-64Bit Standard Edition is ...Show All

• Avi_harush 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

• Ather. Recursive query?

  I have a set of data and I need to actually add a column to the result set based on information contained within the query. For example, SalesmanID  SalesBudget   SalesRegion      Product      Amount 1                      1000                 USA                   Soap          100.50 1         &nbs ...Show All