sql server - QTD MDX calculated value displaying differently on SSRS than SSAS -


i have created ssas cube in sql 2005 , included calculated members mtd, qtd ytd.

with qtd measure want total on 3 months of quarter, not up-to-date value.

now when browse cube number qtd measure correct (total of 3 months of quarter) irrespective of month of quater pass parameter, report pulls data cube shows up-to-date value not total of 3 months. i.e. report gives me correct value when select last month of quarter. report displays sales targets (committments) way. wonder why report showing different values calculated field compared cube? below expression used calculate total on months of quarter.

sum(qtd([dimtime].[hierarchy].parent),[measures].[commitment])

please help.

thanks, lungisa dotye

after struggling decided clear data grid, removing cube fields report data or query. added them 1 one keeping track of cube values , noticed data matches what's on cube browser until when added field details number of days each month of quarter. field added behavior of data changed, think ssrs automatically drills down quarter-to-date level , disregarding targets upcoming months of quarter. decided create calculated field "number of days" on report level , exclude query fields. , solved problem.

i know may not effective solution worked.

thanks, lungisa dotye


Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more