UNION multiple MDX queries in SSAS (powerpivot) -


i have sort of difficulties trying join 2 mdx queries together. when running them separately work fine. script below

with    member [measures].[parametercaption]      [main_incidents].[priority].currentmember.member_caption    member [measures].[parametervalue]      [main_incidents].[priority].currentmember.uniquename    member [measures].[parameterlevel]      [main_incidents].[priority].currentmember.level.ordinal  select    {     [measures].[parametercaption]    ,[measures].[# incidents]    ,[measures].[%sla]   } on columns  ,[main_incidents].[priority].allmembers on rows [model];      member [measures].[parametercaption]      [main_incidents].[usr_directorate].currentmember.member_caption    member [measures].[parametervalue]      [main_incidents].[usr_directorate].currentmember.uniquename    member [measures].[parameterlevel]      [main_incidents].[usr_directorate].currentmember.level.ordinal  select    {     [measures].[parametercaption]    ,[measures].[# incidents]    ,[measures].[%sla]   } on columns  ,[main_incidents].[usr_directorate].allmembers on rows [model];

the important bit me need label column show. want union 2 queries parametercaption captures values "priority" dimension , "directorate" dimension....

please me achieve this?

this bit complex, possible.

union in mdx works members of same hierarchy, achieve need make row members tuples combine 2 hierarchies. can cross joining each of allmembers sets [all] member other hierarchy. need change parameter caption, value , level conditionally value appropriate hierarchy.

this code below:

with    member [measures].[parametercaption]     iif([main_incidents].[priority].currentmember.level.ordinal = 0, [main_incidents].[usr_directorate].currentmember.member_caption, [main_incidents].[priority].currentmember.member_caption)   member [measures].[parametervalue]     iif([main_incidents].[priority].currentmember.level.ordinal = 0, [main_incidents].[usr_directorate].currentmember.uniquename, [main_incidents].[priority].currentmember.uniquename)   member [measures].[parameterlevel]     iif([main_incidents].[priority].currentmember.level.ordinal = 0, [main_incidents].[usr_directorate].currentmember.level.ordinal , [main_incidents].[priority].currentmember.level.ordinal) select    {     [measures].[parametercaption]    ,[measures].[# incidents]    ,[measures].[%sla]   } on columns  ,{     [main_incidents].[priority].allmembers * [main_incidents].[usr_directorate].[all],     [main_incidents].[priority].[all] * [main_incidents].[usr_directorate].allmembers   } on rows [model];

Comments

Post a Comment

Popular posts from this blog

java - Null response to php query in android, even though php works properly -

Image
table i'm trying retrieve above data using 2 php files below. want pass email parameter , return bets user = email. work fine when tested advanced rest client, problem not php. however, when try through android 2 java classes below, null pointer exception (logcat below) , json object returned null. i'm not sure error is, think i'm not passing parameter php , that's why it's producing null response. logcat 05-31 15:10:50.227 26074-26074/com.example.albert.betterapp e/androidruntime﹕ fatal exception: main process: com.example.albert.betterapp, pid: 26074 java.lang.runtimeexception: unable start activity componentinfo{com.example.albert.betterapp/com.example.albert.betterapp.displayallbets}: java.lang.nullpointerexception @ android.app.activitythread.performlaunchactivity(activitythread.java:2292) @ android.app.activitythread.handlelaunchactivity(activitythread.java:2350) @ android.app.activitythread.acce...
Read more

node.js - Using Node without global install -

i'm working on few node & electron (atom shell) projects , i'm curious how them work without user having install node globally. i've seen few applications including node directory in project contains node.exe binary. how go setting node project use binary? edit: thought should add, i've searched everywhere answer this, unrelated results.
Read more

php - CakePHP HttpSockets send array of paramms -

i problem when make request (i can request). $link = 'http://uri/path/?param1=1&sid=2&sid=3&sid=4' $http = $httpsocket = new httpsocket(); $res = $httpsocket->get($link); if check request pr($http); i see : [line] => /url/path/?param1=1&sid%5b0%5d=2&sid%5b1%5d=3&sid%5b2%5d=4 http/1.1 and i'm getting empty response because server doesn't know parameters sid%5b0%5d=2 when try send parameters array : $data = array('param1' => '1', 'sid' => array('2','3', '4')); i see same changes %5b0%5d - additional indexes. how fix it? unfortunately , can not change server side, if send request in browser, i'll normal response in json format. when make request, can parameters this: $param1 = $_get['param1']; $sid= $_get['sid']; tip: use diferente names parameters. have multiples sid. use sid1, sid2, sid3... update: can parameters this:...
Read more