mdx - Differing NON EMPTY behaviour in Analysis Server 2000 and 2008 -

-

we run front-end manager information tool connects sql analysis server provide flexible reporting. front-end builds mdx executes on analysis services, , prettifies result table.

we upgrading sql 2000 sql 2008 , have come across difference in use of non empty in mdx.

this mdx query in question

select non empty {[measures].allmembers} on rows, non empty {} on columns sales

when run on analysis server 2000 returns list of measure member names rows, when run in analysis server 2008 nothing returned.

looking @ mdx think 2008 working expected, , 2000 wrong, has sort of broken our front-end showing nothing in case mdx run (the user expected drag on columns after see, nothing showing, can't this).

so, there reason difference. 'bug' in 2000 fixed in 2008? or there configuration option somewhere can affect returned? (essentially want avoid having make change our front-end cope this!)

thanks.

it's been long enough since i've used ssas 2000 doesn't feel yesterday. can't recall seeing breaking change this. however, non empty on columns feels spurious if intent issue query members. (it's valid, find more robust uis using metadata objects.)

non empty becomes affected implicit slicers, , cube structure may have changed somewhere. if top/default members in non-measures dimensions give null cell values, you'll drop measures.

suppose run same query 

select non empty {[measures].allmembers} on  columns sales

and

select  {[measures].allmembers} on columns sales

in sql server management console. values?

if do, try run these in exact same environment user (for example, debug version of app). security filters , default member settings 2 things leading null rows correctly being filtered.


Comments

Post a Comment

Popular posts from this blog

Javascript line number mapping -

-
magically formatted comments change reported line number of javascript errors in browsers; this: //@line n "f" n line number , f file name. unfortunately, //@line appears ungoogleable. know there documentation on feature, , browsers support it? (i found references here , here .) from can find available in mozilla based browsers. it using js_setoptions command can turn these options on or off depending on values passed. https://developer.mozilla.org/en/js_setoptions
Read more

c# - Is it possible to remove an existing registration from Autofac container builder? -

-
something along lines: builder.registertype<mytype>().as<itype>(); builder.registertype<mytype2>().as<itype>(); builder.deregistertype<mytype>().as<itype>() var container = builder.build(); var types = container.resolve<ienumerable<itype>>(); assert.istrue(types.count == 1); assert.istrue(types[0].gettype == typeof(mytype2)); scenario: go through bunch of assemblies , go register types want make sure have 1 implementation of given type. need before create container. track on own nice if autofac me bit. this cannot done directly using containerbuilder , unless start on new one. mind you, having first built container should able construct new container filtering away unwanted types , reusing registrations first container. this: ... var container = builder.build(); builder = new containerbuilder(); var components = container.componentregistry.registrations .where(cr => cr.activator.limittype != typ...
Read more

php - Mysql PK and FK char(36) vs int(10) -

-
i have read mysql can handle indexes , searches better if tables keys integers rather char(36) uuid's. is worth converting int(10)? note: use 1 server , have have plans use multiple databases concurrently therefore removing 1 of big reasons using uuid. our tables innodb if makes difference. thanks in advance. usually rdbms can handle integer keys pk more efficient, other datatypes. reason how build index column, yes: long dont require string (or other typed) keys, should use integers. however: char(36) , int(10) far away being equal, because int(10) much smaller, char(36). dont know, if require many different keys, should keep in mind. update, complete last paragraph: int(10) 32-bit, char(36) 36 - ^byte^ (= 288-bit). not mean, int consumes less space, means, char(36) has 4 times more different keys.
Read more