cisco0407's Q&A profile

• SQL Server Sum from attribute properties & hierarchy from different dimension tables

  I am using a star schema which has about 9 dimension tables and a fact table. One dimension table has more than 100 attributes and this table has contract limits and premium details. The fact table has the transaction data. I would like get the contract limit(number) using dimension properties function and display in the end user view. One contract has multiple years. The MDX [Contract Dim].[Contract Number]. Properties ( "Limit" ) is not summing up all years and it is not allowing to use sum/aggregate function, it just gets last year's limit. How to get the sum . My second question is about defining hierarchy from two different dimension tables that are linked using Fact table. I was able to do this easily in SSAS 2000 ...Show All

• Smart Device Development Closing Event in Smart Device Application

  Hi, I am actually working on a smart device application and i am having problems to handle the closing event of a form. I have to prompt the user if he really wants to exit with a dialog box. i have put the codes in the closing event but still the form closes without showing the dialogue box. i have also tried the e.cancel = true code but still its not working. can anyone help please Thanks is this the code u need if(DialogResult.Yes == MessageBox.Show("Do u want to exit", "confirm",MessageBoxButtons.YesNo,MessageBoxIcon.Asterisk,MessageBoxDefaultButton.Button1 )) { e.Cancel = false; } else e.Cancel = true; insert this code in the closing e ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Utter newbie wanting to run code

  I've written the basic "first app" as per the instructions given. I'm trying to get it to run but for the life of me I can't find the way to build and run it. The only option available is to build it, which doesn't actually run it. I've tried to publish it but it presents me with an error when I set it up. How do I actually run the app Also: Can you import a ".x" mesh with textures Is there the facility to use a "virtual camera" as a point of view Any help appreciated thx! [moved to GSE forum] The way to run it is either Debug/Start debugging, press f5 or press the 'play' button on the tool bar (little green triangle). Now I think about it not having the ...Show All

• Visual Studio Team System Best Practices for Data Generator Based Tests?

  I'm having a bit of a hard time grasping how to make meaningful tests based on the randomly generated data vs making my test in a transaction where I feed it initial data and check for an expected outcome. For example's sake if I had an SP called DivideTwoCols that would divide colA by colB in table0... If I were making tests with known data, I'd probably make a test using two positives, one negative and one positive, two negatives, colA = 0, colB = 0, and no rows in table0. If I were just testing randomly generated data how would I know I had my cases covered would the random test just pick a random row to try it with using select top 1 colA, colB from table0 order by newid() I can appreciate throwing in some randomness in te ...Show All

• Visual Studio VS 2005 Pro SQL Version

  Which Edition of SQL comes with VS 2005 Pro The VS 2005 Product Comparison shows it coming with SQL Server Developer Edition (which is what I need). But the Trial version I downloaded came with SQL Server Express, which doesn't include any of the BI tools I need. well I have MSDN subscription and from that it has bundled in SQL Server 2005 Express. It maybe different for retail in which case whatever the link states is true I think the trial version has some cuts in it apart from the time constraint but do not quote me. For confirmation, best speak to perhaps PSS (Product Support Services) - even though they are technical support, they maybe able to answer your query: http://support.microsoft.com ...Show All

• Visual Studio Solution Events does not trigger properly

  Hi, I tried to capture 'solution open' event and the 'solution before close' event using the Applition Object Model. It did not work when I first connect the Add-in and then open the solution, but it works fine when I first open the solution and then connect the Add-In. I went through the Connect.cs but I could not find any reason for this. Any idea why is this happening Best regards, Imesh Hi Imesh, Notice that you are NOT using a class variable to hold the instance returned by Connect._applicationObject.Events.SolutionEvents. Your code is equivalent to the wrong code that I exposed in the mentioned article and will be affected in the same way. You have to have a class variable declara ...Show All

• SQL Server Microsoft SQL Server Database File (SqlClient) vs Microsoft SQL Server

  In VS 2005, when we choose database connection, we can choose one of the above. My question is in what situations should we choose MS SQL Server Database File (SqlClient), and when should we choose Microsoft SQL Server I want to deploy a standalone desktop application with a backend database. Which backend database should I should and which of the above connection should I choose Thanks very much for your information. The MS SQL Server Database File data source entry is intended to access local data stored in an instance of MS SQL Server Express 2005 on the same machine as the client application. Building your app in this way would require that your client install ensure that SQL Server Express is a ...Show All

• Visual C# Secure File Downloads

  Hello, I am building a c# web app that will allow users to download files from my website. Once the file download link is clicked, I want to push them to another server where the files are actually located for download. Is there any way within my c# app that I can ensure that the file download session was started from my initial web server and not from an outside person trying to access the files directly on the file web server My goal is to have the downloads on my file web server be secure and not open for access unless they were initiated from my other web server. Thanks for your help. -Dave Thanks Shawn. That was very helpful. I now can detect where the request is coming from and if it was initiate ...Show All

• Windows Forms How do I animate a button click from code?

  This code preforms the button2 operation with button2.PerformClick(), but the user has no indication that button 2 has been clicked. How do I get button2 to go down and back up public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button2_Click(object sender, EventArgs e) { Console.WriteLine("button 2 was clicked."); } private void button1_Click(object sender, EventArgs e) { button2.PerformClick(); } } Thank you B14 Thanks to everyone for their replies. Attached is working code that based on CommonGenius.com 's post. Some may find this solution too complicated. A classmate sugge ...Show All

• Visual Studio Solution and Solution Configuration missing

  Something's happened to Visual Studio which is causing the Solution Configuration dropdown to disappear from new Web Application projects. It's also causing the "root" (ie the Solution) to disappear from the Solution Explorer, too. New Web Sites are fine, and older Web Application projects still have the Solution Config in them, but any new Web Applications don't work. I've tried repairing Visual Studio with no joy. I can't say for sure what has caused this- it's taken me a while to even notice, to be honest! One thing that might be the cause: I installed the Atlas library into VS about three weeks ago... Might that have changed some settings or corrupted something somewhere In Tools-& ...Show All

• Visual Studio 2008 (Pre-release) Exception in MeasureCore

  I'm simply trying to set the Button.Content property to the value of a string, like myimage.jpg.  The Measure method on the FrameworkElement seems to be failing with:  "Overflow or underflow in the arithmetic operation." Is this a bug or what's the issue here   See exception stack below.  Thanks! "at System.Double.Equals(Object obj)    at System.Object.Equals(Object objA, Object objB)    at System.Windows.DependencyObject.Equals(DependencyProperty dp, Object value1, Object value2)    at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex entryIndex, DependencyProperty dp, PropertyMetadata metadata, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEn ...Show All

• SQL Server Reporting Services - Only Measures on Column axis

  Hi, I'm currently using AS 2005 and Reporting Services. I have some results of a query split into age buckets (0-90 days, 91-180 days, etc). I would like to display the buckets, whether there are results or not as I am using them in the column . If I do not include "Non Empty", it returns a huge number of records because there is a cross join with another dimension which does not need to include all records. For example, here is my query: SELECT NON EMPTY { [Measures].[To Bill Amount] } ON COLUMNS , NON EMPTY { ( [Product].[Product Name].[Product Name]. ALLMEMBERS * [Transaction Date].[Age Buckets].[Age Buckets]. ALLMEMBERS ) } ON ROWS FROM ( SELECT ( { [Client].[Client Key].&[2] } ) ON COLUM ...Show All

• Visual C++ runtime error

  --------------------------- Microsoft Visual C++ Runtime Library --------------------------- Runtime Error! Program: C:\WINDOWS\system32\MsiExec.exe This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. --------------------------- OK --------------------------- can anyone explain why i get this error message, if so can anyone please help me get around it. Has anyone found the fix to this problem This has happened after updates mainly and now it happens all the time. I have had the same error message 10 times in the last 5 minutes. ...Show All

• Windows Forms Type on DataGridView Search

  Hi I want to enable a search function where the user can select a column (highlight) and simple type the required search in on the DataGridView. I am using Visual Studio 2005 C# If anyone has any ideas that would be great. Thanks I hope this article will help you http://www.codeproject.com/useritems/RowFilterBuilder.asp ...Show All

• Visual C++ Rewriting C# into C++ for obfuscation purporses

  I would like to rewrite parts of a C# application into C++, so the source code cant be read by tools such as reflector. It seems fairly easy using Managed Assemblies in VC++, but I cant figure out if Managed C++ code is also compliled into CLR. Is this rigth Managed Assemblies seems to be the only way how I can keep the design simply replacint C# syntax with C++. All inputs are welcome. Best regards Soeren Managed C++ does indeed, like C#, compile into CIL. Therefore, the source will be no more "hidden" written in MC++ than VB.Net or C#. The options you do have, though, include Use a code obfuscator to make the compiled CIL less humanly readable. Write specific parts of t ...Show All