Hi
I Have several cubes with measures that are combined into
one virtual cube.
The shared dimension are:
Time (Levels: year,quarter,month,day)
CinemaTheater (Levels: Region,city,Cinema,Showroom)
Daytype (onelevel:{weekday,weeken})
Channel (onelevel: {wap,internet,manual})
Movie (Levels: (Distributor,Movie))
Salesperson ( onelevel: {Ann...200..Qvintus}
The cubes are:
VisitorsCube (Contains data that exist in dimensions
Cinematheater,Daytype,Movie,Time, Channel, Salesperson) with measure NoOfVisitors
CinemaCube (Contains data that exist in dimensions
Cinematheater,Daytype,Movie,Time)with measure Sales
Budget with writeback ((Contains data that exist in dimensions
Cinematheater,Time) with measure budget
NumberOfSeats (exist in dimensions Cinematheater---This is originally a property that I have made a measure) with measure
Seats
When I show several measures for example
Visitor and Seats that works fine until I drill down the time dimension or movie dimension. Then it only shows blanks.
I am more used to cognos tools there when you build the cube you simple decide what should be shown.
There you can choose one the three following:
A Show a contant value - the same as if you did not drilled down
in the time dimension.
B Show zero or N/A.
C Calculate the value depending on a other measure that exist in this level or dimension.
I have asked my friends who are mdx masters, but they do not know of any easy solution like in Cognos Transformer.
Now I am trying to make a measure as a calculated member.
That will not drilldown in the dimension where does not exist something like
tuple: {CinemaTheater.currentmember.Time.donotdrilldown,Daytyp.donotdrilldown,channel.donotdrilldown.....}
I do cannot get my mdx scheme to work however.
Do you think I am the right track? Or am I trying to use a Cognos way in Microsoft world?
The controller in the CinemaTheater companie wants a huge cube with all measures at hand.
Best Regards
Patrik
patriklindstrom--at---hotmail.com
I Have several cubes with measures that are combined into
one virtual cube.
The shared dimension are:
Time (Levels: year,quarter,month,day)
CinemaTheater (Levels: Region,city,Cinema,Showroom)
Daytype (onelevel:{weekday,weeken})
Channel (onelevel: {wap,internet,manual})
Movie (Levels: (Distributor,Movie))
Salesperson ( onelevel: {Ann...200..Qvintus}
The cubes are:
VisitorsCube (Contains data that exist in dimensions
Cinematheater,Daytype,Movie,Time, Channel, Salesperson) with measure NoOfVisitors
CinemaCube (Contains data that exist in dimensions
Cinematheater,Daytype,Movie,Time)with measure Sales
Budget with writeback ((Contains data that exist in dimensions
Cinematheater,Time) with measure budget
NumberOfSeats (exist in dimensions Cinematheater---This is originally a property that I have made a measure) with measure
Seats
When I show several measures for example
Visitor and Seats that works fine until I drill down the time dimension or movie dimension. Then it only shows blanks.
I am more used to cognos tools there when you build the cube you simple decide what should be shown.
There you can choose one the three following:
A Show a contant value - the same as if you did not drilled down
in the time dimension.
B Show zero or N/A.
C Calculate the value depending on a other measure that exist in this level or dimension.
I have asked my friends who are mdx masters, but they do not know of any easy solution like in Cognos Transformer.
Now I am trying to make a measure as a calculated member.
That will not drilldown in the dimension where does not exist something like
tuple: {CinemaTheater.currentmember.Time.donotdrilldown,Daytyp.donotdrilldown,channel.donotdrilldown.....}
I do cannot get my mdx scheme to work however.
Do you think I am the right track? Or am I trying to use a Cognos way in Microsoft world?
The controller in the CinemaTheater companie wants a huge cube with all measures at hand.
Best Regards
Patrik
patriklindstrom--at---hotmail.com