markovuksanovic's Q&A profile

• SQL Server KPI Status and Indicators

  I'm building some tools to help users define KPIs in Analysis Services without needing to know the grungy details of MDX expressions. Ideally these KPIs would be useful with the various BI clients - BSM, Sharepoint 2007 Report Center, Excel 2007, PerformancePoint, etc. One of the things that I'm unclear on is how to properly handle KPI indicators. It seems that SSAS defines a standard set of indicators (traffic light, guage, etc). Here's a few questions I have about those indicators * Is there way to enumerate the set of indicators * Is the set of indicators extensible Or is it a hardcoded set * The values of the KPI_STATUS_GRAPHIC property for a KPI are things like "Standard Arrow" and "Cylinder". Are those names h ...Show All

• Visual C# Properties.Settings; ArrayList and a custom object

  Hello, I am writing a Windows Forms application using .NET Framework 2.0 and Visual Studio 2005. I would like to use Properties.Settings class to persist a collection of custom objects, so I can created a property called Connections of type System.Collections.ArrayList using the Properties designer in VS. At run-time I populate an arraylist with instances of my class and then I set the Connections property to this arraylist. Then, I execute the Save command on the Settings.Default. The Save command does not generate an error, but no settings are persisted either. Do I need to do something special with ArrayList and my class (serialization, perhaps) in order for settings to be persisted correctly Many thanks for your help! ...Show All

• Visual Studio Express Editions Several C# questions

  I have a couple of questions I've come across with this application that I'm writing, and I'm hoping that somebody here can help me out. Here's a quick background of what my application is ultimately supposed to do: There is an MDI Container window called MainWindow that can create MDI Children called ServerWindow which contain a connection to a TCP server. Based on information received and parsed over the TCP connection, the ServerWindow can create additional MDI Children, TypeAWindow and TypeBWindow. Here are my questions: 1. Can you give me a good example of how I should be setting up this TCP connection to be processed in the background The remote server sends it data without my application requesting it first (Asynchronously is the t ...Show All

• SQL Server Openrowset / OpenQuery / 4-part name performance question

  Trying to find out what the performance differences are when using Openrowset (ad-hoc query), OpenQuery(linked server), and four-part names (linked server) Here are the specific queries being tested: select * from openquery(myserver,'select * from TestDB.dbo.testtable') select * from openrowset 'SQLOLEDB','Server=myserver;uid=myid;pwd=mypass;', 'select * from TestDB.dbo.testtable') select * from myserver.TestDB.dbo.testtable Whe I do an execution plan, the first 2 queries return identical plans with an estimated time of 3.36 (remote scan operator) The third query uses a remote query operator, with estimated time of .406. Any help explaining what's going on and recommendations on where to go Thanks, Rich Currey ...Show All

• SQL Server SQL Server XE Instances in .Net

  Hi, I've got an application which uses the DBFactory Provider to enumerate a list of available SQL instances on the local network. I've just reformatted though and put everything back on, and my application will now see the sql server instances on the network, but not the instances on the local computer (only the server name), eg, it will see "BEN\SQLEXPRESS" on a computer (BEN) on the local network, and give the version info, etc, but it only sees "DAN" instead of "DAN\PCP" and "DAN\SQLEXPRESS" on the local computer (DAN). Regards, Ben Do you have the SQL Server browser service running on your machine HTH, jens Suessmeyer. --- http://www.sqlserver2005.de ...Show All

• Visual Studio Team System combine team editions

  I have scanned through the forums for an answer to this, but to no avail. My question is simple, because our developers wear multiple hats it is necessary for an individual to have access to both Software Developer and Database Developer versions of Team edition on their system. Is this possible As Luis already replied - yes, you can mix & match and they integrate together seamlessly. If you need two or more of the "roles", you might be better off licensing the "Team Suite" edition which includes all of the roles for about the same price as any two roles individually. ...Show All

• SQL Server Calculated Measu Formula limitations

  Hi, I am using AMO to programmaticaly create the SSAS objects like Cubes, MeasureGroups, Measures, Calculated Measure, partitions .etc. I pick the necessary information from an existing Oracle OLAP/datawarehouse. In the Oracle OLAP the calculated measure can contain any formulae which the oracle db can support. This means its a huge list....! for example, Log, Decode functions. Though SQL Db provides these functions, they are not avaliable to use directly in the MDXScript of the Calculated Measure. so now when I am synchronizing the Oracle OLAP to SSAS programmatically at runtime, how do I resolve these inconsistencies in the formulae Regards Vijay R Hi Edward, I guess I did not explain it correctly, I&n ...Show All

• Visual Studio Express Editions using visual studio (express) to play media files

  is there a way, perhaps an sdk (software devlopment kit) to allow one to play media files using (preferably) visualBasic...  [movies, mp3, etc,  not just .wav] what i want to make is a simpler media player.    MrZkitten wrote: will the direct x, sdk work in visual basic absolutely my friend! it works with C#/VB and C++ also I believe. you just need to add the right references and use the classes you need to use - there are tons of examples included in the SDK as well as documentation - im sure you will find something useful there. I'm glad I could be of your assistance :-) ...Show All

• SQL Server Either the user, UHRC\Administrator doesnot have access to the Adventure Works DW Database or the database doesnot exist.

  Hi all, I am trying to create Linked report, when i click on the preview tab of the Adventure Works Sample reports Project it prompts an error that an error occurred during local report processing Query execution failed for data set. Either the user, UHRC\Administrator doesnot have access to the Adventure Works DW Database or the database doesnot exist. This is a security related question. Could someone help me to go about this. Thanx in advance. Ronald Hi, Adventureworks DW is the datawarehouse of Adventureworks, if you are sure that you installed that correct, you can open up SSMS Open the connect dialog in the object Explorer > Analysis Services > Databases > Roles > (Check the roles, if the role t ...Show All

• .NET Development XMLTextWiter Stops Output with no Exception

  Hi, I've started a project using XML writetextwriter and it's really the first time I've written an XML application. The XMLtextwriter goes through the entire Database and just stops writing at the very end with no exception - mid item - last item. The Output looks like this: <Service>Violence</Service> <Description>When you're worried about violence</Description> <Para1>The organizations listed below provide trauma counseling services, services to those who have been sexually abused, and help in crisis situations involving survivors or witnesses to violence.</Para1> <Narrative>More complete information about these organization’s locations, contact person, hours of operation, fees c ...Show All

• Microsoft ISV Community Center Forums How to declare activeX object in source code instead on the form?

  Hi everyone, My questio is about VB6 ..... I want to declare a ActiveX object in the source instead of "drag and drop" a ActiveX object into the form. Let's say, I want to declare a timer dynamatically at run time, so I want a way to decalre a timer in the source. I found code from the other forums seem to do the job but it would not compile for me: Dim withevents my_timer as timer 'Or Private withevents my_timer as timer   'In form_load() set my_timer = new timer ()  <---- this line would not compile Any idea Thanks Kit === Are you trying to create an ActiveX component == Yes Dim withevents my_comm as mscomm 'Or Private withevents my_comm as mscomm 'In form_load() set my_comm = new ...Show All

• .NET Development how to use a cs files objects at runtime?

  I have a program that creates a cs file. I would like to access it's classes at runtime and create objects of it's classes and use them. How should I approach it. Is there a way I can progmatically compile and create instances of it's objects for use Thanks, Devin http://msdn2.microsoft.com/en-us/library/microsoft.csharp.csharpcodeprovider.aspx#Mtps_DropDownFilterText ...Show All

• Software Development for Windows Vista Intel(R) 82801ER SATA RAID Controller

  When I want setup Vista RC1 from DOS, I will need to install raid driver. When I put floppy into floppy-drive, setup begin copy driver-files to HDD, when I will seen "blue screen" with error. This driver was worked correctly in Vista Beta 2. How can I correct this problem. I have the same issue. I tried the newest driver I could find on the Intel website without success. Andy. ...Show All

• SQL Server problem with key encryption

  Hello, I am using report server sql express. The report was working until yesturday.Sudenly the report did'nt work and give an error : The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help Bad Data. I delete the key and change the data source.Now it works fine! My problem is that this is not the first time that it happens!!! I don't know what the cause of the problem and why suddenly after some times,the report give an erraur that i have to delete the key!! i ...Show All

• SQL Server EMail Subscription Error

  All of a sudden, the e-mail subscriptions for a report quit being sent. Running Sql 2000 Microsoft SQL Server Reporting Services Version 8.00.743.00 Here is the log error: aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing. aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Stac ...Show All