Xadja's Q&A profile
SQL Server Using Filter function in a Calculated Member
Hello Guys, I am new to Analysis Services and using 2005. I use the sharepoint portal to pubish the dashboard. This is my UI for the cube built in Analysis Services. I am unable to comprehend why the Filter function will not work with the Calcuated Member. The requirement is to get the Total Employee head count excluding employees in 2 departments. How do I go about doing this... I tried Filter() and Except() and nothing seems to work... Please help... This is what I have so far... Here is what I have... CREATE MEMBER CURRENTCUBE.[MEASURES].[Total Active Head Count] AS ([Measures].[Active Employee Head Count],Sum( Except([dimensionEmployee].[Employee Department].[All].Children , {[dimensionEmployee].[Employee Department].&[Services ...Show All
SQL Server Backing up SQL + VSS
Hi guys, I need some help concerning the backup of SQL Server 2005. I want to use the VSS, and I know that it's certified because the SQL writer it's internal to the software so I could use it and I'll be sure that the consistency it's granted What I want It's to link the requestor (NT backup) to the VSS that are coming from the storage vendor (in my case IBM). So I'll use the Flashcopy on the storage subsystem for the backup porpouse. Does anyone any idea if it's work Any experience Txs ...Show All
Visual Studio Express Editions How do I specify the browser for the ASP.NET IDE
When I installed ASP.NET 2.0 my default browser was Firefox. Now my default browser is IE 7.0, however, when I test a page the Firefox browser is opened. How do I make the IDE use the IE browser I would try posting you comment on the Visual Web developer group on http://forums.asp.net you might get an answer here but most of the web developers hang out on the above site. ...Show All
SQL Server Editing in Querry Analyzer not in EM
Hello, In SQL if we want to edit a row in a table then we have two ways to do the same, 1. Execute a command to Update the records in sql through querry analyzer. 2. Go to enterprise manager and then open the table and update a new row. But can't we do the editing in the querry analyzer is there any way to do this. That means i select all the records from my table using the following querry. Select * from MyTable and then performs editing in the querry analyzer without executing any update command and without using the Enterprise manager. Can we do this Bye and TC I understand your issue... If the table has duplicate rows then it wont allow to edit in QA. (it will allow to edit other tables, ...Show All
Windows Forms Displaying data thru grid
I'm migrating an application VB6 to VB.NET. No its not a question about upgrade. In VB6, a third party grid was used to display data. I'm trying to use datagrid to display data. But to use Datagrid, I need to extract data from a Datatable. Is there any other possible way to add data to a Datagrid As I wont be able to add a new table. I dont think you can do this in .NET 1.1 (VS2003) but in .NET 2.0, you can do the above that I had stated plus direct additions/modifications to the datagridview: dim myValues() as Object = { "hello", "1" } Me .theDataGridView.Column.Add("ColumnName", "HeaderName") Me .theDataGridView.Rows.Add(myValues) this ...Show All
SQL Server SSIS logic for storedprocedures
Hi, Do you have any suggestions of how to transform the below code in SSIS I guess we should use foreach loop container...... also i would appreciate if you can post some related articles. Praveen Dayanithi wrote: Hi, Sorry i thought the exact code can make you understand my problem easily.....neways this is wat happens in that code.... 1) Field1,field2,.. are fetched into a cursor from table1. 2) For each and every row in the cursor all the corresponding(may be severals records) records ar pulled out from a merge join resultser of table2 and table3. This is wat code does.... can you tell me ...Show All
Smart Device Development Read and write XML files
Hi, I want to build a software for pc pocket on Windows Mobile 5.0 using VS 2005. I create solutions and add one xml file item into the project, called "data.xml". My application when loading will load xml file like this: myData = new XMLDocument() myData.load(" \\data.xml "); There are 3 things: 1. Is this the right way to load xml data Any suggestion for a good way to do it 2. Is data.xml automatically deployed together with the application or do I need to do any step to include it when deploy on to the emulater 3. I got this error so far: Could not find file " \\data.xml " Thanks Bao Nguyen Hi, I am developing a smart device app. i am also having the same issue. Can u ...Show All
Visual Studio Team System How to get the VS2003 Plugin for Team System and TeamPlain Eclipse Plugin for Team System?
How to get the VS2003 Plugin for Team System and TeamPlain Eclipse Plugin for Team System Thanks a lot! Have you looked here for the TeamPlain plugin http://www.devbiz.com/teamplain/ Here is the link to the MSSCCI Provider that enables use of TF Version Control with VS 2003 http://www.microsoft.com/downloads/details.aspx FamilyId=87E1FFBD-A484-4C3A-8776-D560AB1E6198&displaylang=en Does this help ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Vertex Shaders without Pixel Shaders
Sadly, XNA Beta 2 does not let you use vertex shaders without pixel shaders... If you are targetting GF2, GF4MX or Radeon 7xxx old hardware, here is a workaround: bool [ ] verifiedCanDraw ; fi = device.GetType ( ).GetField ( "_verifiedCanDraw" , BindingFlags.NonPublic | BindingFlags.Instance ); verifiedCanDraw = ( bool [ ] ) ( ( fi.GetValue ( device ) ) ); for ( int i = 0 ; i < verifiedCanDraw.Length ; i++ ) { verifiedCanDraw [ i ] = true; } Will XNA users get a fix for this Even if we removed checking for pixel shaders being set, XNA would not work correctly on cards without pixel shaders. All of our graphics API is based around shaders. Our Sprite ...Show All
.NET Development Custom (inherited) ConfigurationSection saved using Configuration.Save() Problem! Please Help!
I have taken a common Generic ConfigurationSection that was posted on some public forums a while back and modified it to be a fully generic ConfigurationSection for use on any generic object type. The purpose is to be able to write a Configuration Object that uses Xml Serialization attributes for how to write the XML configuration section. Well, everything works excellent, however, there is a problem. ObjectConfigurationSection and ConfigurationObject classes are defined in a shared assembly that is registered in the GAC and re-used. This assembly has a high likelihood of being upgraded over time, but I DO NOT want to have to upgrade the product. Since GAC assembly references in the <configSections><section> type attribute ...Show All
Visual Studio Deploy web app with ReportViewer to hosted site EMBEDDED mode
I'm using a ReportViewer control in an .aspx page using ASP.NET 2.0 in Visual Studio 2005 Beta2. I want to deploy this ReportViewer control to my hosted site at WebHost4Life in "local" or "embedded" mode. My report runs fine on my development machine. But when I deploy it to my hosted website at WebHost4Life, I'm was getting this error. Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11 or one of its dependencies. The system cannot find the file specified. I then searched my development machine and found these two files, which I then copied to the bin folder in my hosted website: Microsoft.ReportViewer.Common.dll M ...Show All
Visual C++ Format Specifier question
Hello All, Can anyone tell me the correct format specifier for ULONGLONG datatype in C++ language for printf function Thanks in Advance. %llu ...Show All
SQL Server How to access the data from a custom data mining plugin ?
I'm stucked in a problem and I thought if you would be so kind as to helping me to resolve it. I'm implementing a clustering algorithm plugin for text mining. I've already read the tutorials and sample codes provided by the MSDN Library. Well... My problem is: I can't go through the data when the Predict method is called. I've read that this method implements the "core" of the custom algorithms. Here is a small snippet of my code for you to understand my doubt: STDMETHODIMP ALGORITHM::Predict(/* [in] */ IDMContextServices* in_pContext,/* [in] */ DM_PREDICTION_FLAGS in_Flags,/* [in] */ IDMAttributeGroup* in_pPredAttGroup,/* [in] */ DM_CaseID in_CaseID, /* [in] */ ULONG in_ulCaseValues,/* [in] */ DM_ATTRIBUTE_VALUE* in_rgV ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Shader from SDK throwing Exception?
Hi, I'm having problems getting a shader (glow.fx) from the DirectX SDK to work within XNA. The following error is being thrown by DrawIndexPrimitives: An unhandled exception of type 'System.InvalidOperationException' occurred in Microsoft.Xna.Framework.dll Additional information: Both a valid vertex shader and pixel shader (or valid effect) must be set on the device before draw operations may be performed. I stripped out all the excess code and resorted to a sample from the XNA documentation (Effects I think it was) and replaced all the expected fields, so the initialisation looks like this: effect = content.Load< Effect >( "Glow" ); effect.Parameters[ "View" ].SetValue( view ); effect. ...Show All
Software Development for Windows Vista VX3000 Compatibility issue with Vista build 5728
I saw a thread earlier about VX3000 driver not being compatible with RC1 (build 5600), but the guy mentioned that it was fixed later in a different build. I have build 5728 and it still won't install (harddrive space too small error), so I was wondering which version is it exactly that this issue was fixed Hello ghos401, I have been looking into this issue and it appears to have been bugged and we are working with the vendor to finish up the code fixes. I do not see a specific build where this was checked-in so it looks like we are still working on it. This would explain why you didn't get this working in 5728. Thanks, Louis Shanks ...Show All
