Posts

SSAS 2008 MDX Query -Member properties access in a Query

friends ,        have below mentioend query mdx query  : with member [last3monthsavg_sale] sum([last3monthdays],[measures].[sale qty])/3 member [last3monthsavg_prod] sum ([last3monthdays],[measures].[tot_unq_prod_out])  /sum([last3monthdays],[measures].[cov_tot_unq_out]) member [last3monthsavg_cov] sum ([last3monthdays],[measures].[tot_unq_cov_out])  /sum([last3monthdays],[measures].[cov_tot_unq_out]) member [gpil_perm] sum([last3months],sum(iif([measures].[perm_merch_qty]=0,null,[measures].[perm_merch_qty]),[product].[company-product].[company].&[3] )) member [prodcat_uniquename] strtomember(@prodcat).uniquename member [wd_uniquename] [outlet].[region].currentmember.uniquename member [number_outlets] as  filter(descendants([outlet].[region].currentmember,[outlet].[region].[outlet]),[sale_qty_mtd] >0).count select  {[number_outlets],[wd_uniquename],[sale_qty_mtd], [prodcat_uniquename],[measures...

Yet another issue....XamlReader.Load

first off, below works... layoutroot.children.clear(); layoutroot.children.add( xamlreader .load( "<textblock xmlns=\"http://schemas.microsoft.com/winfx/2006/xaml/presentation\" xmlns:x=\"http://schemas.microsoft.com/winfx/2006/xaml\" text=\"testblock has been added!\" />" .tostring()) as uielement );  but when try: layoutroot.children.clear(); layoutroot.children.add( xamlreader .load( @"<liquidmenu:mainmenu x:name=""filemenu"" itemselected=""testmenu_itemselected"" height=""30"" width=""987"" d:layoutoverrides=""width, height, verticalmargin"" xmlns=""http://schemas.microsoft.com/client/2007"" xmlns:x=""http://schemas.microsoft.com/winfx/2006/xaml""><liquidmenu:mainmenu.items xmlns=""http://schemas.microsoft.com/client/2007"" xmlns:x="...

August SSAS Guru - Festival of the Awesome SSAS

Image
it's here @ last! the august round of technet technical guru competition! the quality , quantity of entries has been beyond our wildest expectations lately, epic posts , useful snippets bursting out of seams of technet wiki. so please come forth once again, oh mighty techie, , shower insight! join in august festival of technet guru! open heart , feed many hungry minds! for month, when heroes cut leather, chiselled stone, forged in fire of knowledge. month when legends born, , epics scripted. all have add article technet wiki own specialist field. fits 1 of categories listed on submissions page. copy in own blog posts, forum solution, white paper, or had solve own day's work today. drop nifty knowledge, or superb snippets, , become microsoft technology guru of month! this official microsoft technet recognition, people such yourselves can noticed! how win 1) please copy on microsoft technical solutions , revelations technet wiki . 2...

Confirmation needed about TFS upgrade and original server both running on same network.

we have a tfs 2008 server running on our network. it's time upgrade created new tfs2010 test lab server (off network). ths tfs 2008 server fresh os install not clone or "image" of tfs 2008 box. on tfs 2010 box installed sharepoint 2010, copied tfs databases the tfs 2008 server, , successfuly upgraded sharepoint 2010 component. next i want to upgrade tfs component but want move tfs 2010 machine test lab same network our tfs 2008 server. both servers @ same time.  there forseeable issues (e.g. related tfs guids) setup? tia, barkingdog there no issues having both servers @ same time.  follow instructions here: http://msdn.microsoft.com/en-us/library/ms252516.aspx .  explains need restore data different server. steps dealing " tfsconfig" important work ones remap db settings new server. esteban garcia - my blog Arch...

major difference between sp and trigger

hi stored procedure , trigger runs on serverside , runs on client side. dear kanthk, have @ : http://www.sqlservercentral.com/columnists/gvijayakumar/storedprocedurevstriggers.asp hth, suprotim agarwal SQL Server  >  SQL Server Data Access

ALM - VM crashing abruptly

my alm vm tfs is not working, when open vm try connect tfs shows error - can not connect tfs database, although sql server running on machine. when open database see databases (suspect) status - can 1 let me know how fix problem. here solution - repeat process database in vm http://support.powerdnn.com/kb/a398/how-to-repair-a-suspect-database-in-mssql Archived Forums V  >  Team Foundation Server - General

COM+ service is not working in Windows Server 2003

my web application calling the com+ service in windows server 2003 , not working . but, same com+ service running in windows server 2003 , responds web application. actually, everything till last week. server application log shows below message. bounce server , restarted service, doesn't work out. server application log message: the average call duration has exceeded 10 minutes. if not expected behavior, please see article 910904 in microsoft knowledge base @ http://support.microsoft.com details on how use com+ autodump feature automatically generate dump files and/or terminate process if problem occurs again. server application id: {1e788485-b114-4d20-bb12-6e7c5b90eb46} server application instance id: {281fefe6-142d-45bc-908f-46ddcacc6869} server application name: idmbypass have checked kb article 910904? http://support.microsoft.com/kb/910904 this article describes how collect , analyze dump file can resolve issue. hope helps! please rem...