AdamReith's Q&A profile

• SQL Server OWC 11 XML out of sync with OLAP Cubes

  Hi I am using the OWC 11 Pivottable in a Windows Client App to show OLAP cube data and to change OLAP cube date (writeback). We store the XMLDATA for a Pivottabel setup, so that next time the user enters they see the Pivot tabel as it was when they last left it. ...or that is the idea. The problem is that our OLAP cubes is updated daily via our ETL flow. These updates may change dimension values in the OLAP, causing the OWC XML stored in the client to get out of synch. For the user this means that a column may disappear in the OWC. We are struggling to establish a system that keeps the XML data for the OWC updated when changes are detected in the ETL flow. Have you had a similar task that you have solved Do you know of an ...Show All

• SQL Server Export To Excel Problem

  I have a report which contains a merged cells on it which contains a lengthy..when I tried to view the report in the Reporting Services Viewer it works just fine showing all the contents having a 3 rows of data..until I exports it to Excel..the part where the merged cell is located was suppressed into a 1 row hiding the other rows..this was true in a Microsoft Excel..but if we view the exported report in an Open Office environment..it just works fine! Is this already a known issue Is there any issues on what version of Reporting Services is used Is the Service Pack used is also an issue for this Or is it really a bug for viewing a report with that kind of scenario in Excel It would be great to fix this kind of issue..any help regardi ...Show All

• Smart Device Development Extending Context menu for Windows mobile 5.0 Samrtphone Contacts

  I have a Cab project which extends contact's contextmenu items. But When I installed the same cab file on smartphone it installed successfully but contextmenu items remains same Could there be any change in the installation file. this is my ini file to built the cab file [Version] Signature   = "$Windows NT$"        Provider    = "MyProject"            CESignature = "$Windows CE$"        [CEStrings] AppName     = "MyWireless"     InstallDir  = %CE1%\%AppName%       [Strings] NOW_PPC_Dir     = D:\Projects\MyOffice\OriginalPocketPC\ ...Show All

• .NET Development Issue with setting A2A bit

  Hi All, I was wondering if these is anyway to set the A2A (Allow to Authenticate Bit) using ADSI script. I’m able to do it when I’m trying to do it under a Domain Admin privilege. But the current production system wouldn’t allow such action performed automatically (Basically a security constraint). And when I tried doing the same using any other role (Low privilege) it didn’t worked out. This is very critical for me. I would really appreciate any help on this. Thanks in advance. Thanks & Regards, Biswa I’m able to do it when I’m trying to do it under a Domain Admin privilege. But the current production system wouldn’t allow such action performed automatically (Basically a ...Show All

• Community Chat This Time

  http://members.cox.net/wildman3/thisTime.html Best Effort yet! This Time It Won't Take Long, made in Windows Movie Maker, with special effesx. Comments welcome on SoapBox Thanks Treyt Haltom ...Show All

• SQL Server Hiding measures above Country level

  Hello, I have the following problem I would appreciate your help with: I am designing a cube “Cost Benchmarking” using Analysis Server 2000 with the following structure (simplified for the sake of this post): Dimensions: Countries (levels: (All), Regions, Countries) Clients (levels: Client) Media (levels: TV Station) Months (levels: Years, Quarters, Months) Measures: Cost (amount of money the clients spent on advertising, in local currency), Cost in USD (Cost converted to USD at the fact record level), Impressions (raw number of impressions the ad campaign achieved, in thousands), CPM (Cost Per Thousand impressions, calculated = Cost/Impressions) The problem is that several measures do not make business sense to aggregate above the count ...Show All

• Visual Studio Team System Velocity and Rough Order of Magnitude

  When estimating or calculating a team's velocity I would expect that the velocity would be expressed in the number of ROM's the team will deliver or has delivered because this would take into account the differences in size of the scenarios. If I look at the velocity reports in TFS, it seems that only the number of scenarios is taken into account and not their size. Am I misinterpreting things or do I have to create a custom report if I want to have the ROM included in the velocity calculation Any suggestions Hi Chris, On your two questions: Currently the ROM field is not on the CMMI template. I willl bring to the team and verify how the "Estimate" field could be used in t ...Show All

• SQL Server Sharepoint integration

  Hi all, I've tried 3 times to integrate RS in Sharepoint and I always have the same result. I can't see the new section in sharepoint central administration under application management. I didn't get any errors while installing any of the components. RS and Sharepoint are on the same machine and I carefully followed the step to integrate RS in Sharepoint Can someone help me on this thx Fred Got it! My collegue found it...I wasn't in the site collection admin in central admin. Thanks again Josh for pointing me in the right direction Fred ...Show All

• Windows Forms Context Menu In GridView

  How can I have context menu in Gridview upon right clicking at any where in gridview.Can any one plz help me up... Thanks in adavance.... With regards, mahender Hai, Well Mine is Server side application.I am Using gridview.My VS is 2005.Context menu Displays Properly when I try to use textbox as a control.Context menu COme over the Control.AWhen i try to replace textbox with dropdownlist .The Context menu is display backside of Dropdownlist.i mean it looks like Context menu upon tht Dropdownlist occurs....I am using IE7.0 With regards, Mahender ...Show All

• SQL Server sql problem

  hi, i want to know how to do that: table: costtypes fields : typecode values: amount, vat, duty, table bills: fields:  billid, costtype, amount value bi1      amount    1000 bi1     vat               10 bi2    amount        200 i need to create a view that will display amount, vat, duty as fields. note that these are values in the table. so that i will have billid       amount     vat     duty bi1          ...Show All

• .NET Development Using "unique" with "field xpath=" value being variable instead of fixed

  Hi, I have a case where my "unique" identifier field name (in an xsd) can take on different values (based on another value in the xml). My case is validating people--which can either be identified by a Social Security Number or a UniqueId. I’d like the xsd to validate based on the SSN or UniqueId specified in the xml. HERE'S THE "FIXED" CASE (which works fine for validating against a fixed field name – SSN in this case): For a "fixed" case (where only SSN is the unique value): [xsd fragment] <xs:unique name="ProfileUnique"> <xs:selector xpath="Profiles/Profile"/> <xs:field xpath="Ssn"/> </xs:unique> ...Show All

• .NET Development Serializing a DataGridView component

  I have a DataGridView displayed on my GUI that I manually populate (i.e., there is no ADO.NET involved). How can I easily persist the data that I place in it when the app closes and repopulate the grid with the persisted data when the app opens thx in advance, todd The method outlined in the link seems kind of complicated... All the data stored in my grid is computed. I don't have any business objects nor binding objects. It seems like a waste of resources to loop thru all the cells in the grid, get each cell value, copy it into an instantiated class (that I don't need), copy the object to a generic list (that I don't need), and then call the serialize method on the generic list. What I want t ...Show All

• .NET Development SecurityException when registering event on remoting client

  I'm learning about remoting and can't explain an exception I get when I'm trying to register an event at the client side. I'm sure it's just a tiny detail I'm missing could you please help All assemblies are full trust and signed. If I delete the statement "s.OnTextChanged += new TextChangedEventHandler(OnTextChanged);" in the file Client.cs it works, otherwise there is an SecurityException thrown: "Type System.DelegateSerializationHolder and the types derived from it (such as System.DelegateSerializationHolder) are not permitted to be deserialized at this security level." Thank you very much for your help! Andreas Status.dll ========== using System; [Serializable] public delegate void TextChangedEventHandle ...Show All

• Visual C++ How to change data type from TCHAR * to LPWSTR?

  How to change data type from TCHAR * to LPWSTR Thank you very much. In the following statement: TCHAR *titleItems[10]; DrawTextEx(pDC->m_hDC, (unsigned short *)titleItems[item], lstrlen(titleItems[item]), &drawRect, orientFlag[item], NULL); when I compile the project ,it has the following error:Error 1515 error C2664: 'DrawTextExW' : cannot convert parameter 2 from 'unsigned short *' to 'LPWSTR' e:reeview.cpp 1280. It is a example of changing TCHAR* into LPWSTR, CAN you tell me how to realize the data conversion from 'unsigned short *' to 'LPWSTR' Thanks you very much. ...Show All

• SQL Server Unnatended uninstallation

  Does anyone knows how to Uninstall SQL Server Express from command promt in unnatended way I've already achieve the unnatended Installation but i try the reverse steps to uninstall and they didn't work. Any information wolud be helpful I've already tried that but two things happen, if the " are closed after setup.exe as you tell me an error message appears idicating that that the modifier is not valid: "qb", in the other hand if the " are colosed before setup.exe for example "C:\Program files\Microsoft SQL Server\90\Setup Bootstrap" setup.exe /qb REMOVE=ALL INSTANCENAME=SQLEXPRESS a message appears indicating that for Installing and configuring system components you must ...Show All