ssas - MDX Group Dimensions y new Dimension -

-

i'm brand new in cube world , need query extending values form dimensions. example: having dimension [time].[numeric month], values [time].[numeric month].&[1]..[time].[numeric month].&[12]

what need group values this

[time].[numeric month].&[1]...[time].[numeric month].&[4] = [time].[numeric month].&[5]...[time].[numeric month].&[12] = b

(is example)

and perform query wich result show on rows

a |->1 |->2 |->3 |->4 b |->5 |->6 |->7 |->8 |->9 |->10 |->11 |->12

i grouping when tried use same hierarchy used grouping level of row i've error(it make sense) of hierarchy used more once

it's possible kind of query?

this mdx:

with    member [tiempo].[mes numerico].[a]      [tiempo].[mes numerico].&[1]    member [tiempo].[mes numerico].[a         ]      aggregate     (       {         [tiempo].[mes numerico].&[1]        ,[tiempo].[mes numerico].&[2]        ,[tiempo].[mes numerico].&[3]       }     )    member [tiempo].[mes numerico].[d         ]      aggregate     (       {         [tiempo].[mes numerico].&[10]        ,[tiempo].[mes numerico].&[11]        ,[tiempo].[mes numerico].&[12]       }     )    member [measures].[proyectos tiempos-horas40538889]      [measures].[proyectos tiempos-horas]  select    non empty      (       [tiempo].[mes numerico]      ,         {           [tiempo].[mes numerico].[a         ]          ,[tiempo].[mes numerico].[d         ]         }       *          {[measures].[proyectos tiempos-horas40538889]}     ) on columns [visionarisdw];

probably should work:

with    member [tiempo].[mes numerico].[a]        aggregate      (            {             [tiempo].[mes numerico].&[1]            ,[tiempo].[mes numerico].&[2]            ,[tiempo].[mes numerico].&[3]           }           , [measures].[proyectos tiempos-horas]      )    member [tiempo].[mes numerico].[b]        aggregate      (              {             [tiempo].[mes numerico].&[4]            ,[tiempo].[mes numerico].&[5]            ,[tiempo].[mes numerico].&[6]           }           , [measures].[proyectos tiempos-horas]       )    member [measures].[proyectos tiempos-horas40538889]      [measures].[proyectos tiempos-horas]   select     non empty [measures].[proyectos tiempos-horas40538889] on columns,    {       [tiempo].[mes numerico].&[1],       [tiempo].[mes numerico].&[2],       [tiempo].[mes numerico].&[3],       [tiempo].[mes numerico].[a],       [tiempo].[mes numerico].&[4],       [tiempo].[mes numerico].&[5],       [tiempo].[mes numerico].&[6],       [tiempo].[mes numerico].[b]   } on rows  [visionarisdw];

Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more