(Msg. 2) Posted: Sat Feb 02, 2008 12:51 am
Post subject: Re: Order by Measure [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
not possible except when you create named sets, but a named set is "static"
(evaluated 1 time) and only available to applications which support this.
"Jason" wrote in message
> Hello, is it possible to order by a measure in the cube?
>
> Pivot tables let you sort by a measure, but I would like set the default
> sort for a particular measure on the server.
>
> Thanks,
> Jason
> http://www.stockpickbloggers.com
(Msg. 3) Posted: Sun Feb 03, 2008 1:29 pm
Post subject: Re: Order by Measure [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thanks Jeje.
Jason
"Jeje" wrote:
> not possible except when you create named sets, but a named set is "static"
> (evaluated 1 time) and only available to applications which support this.
>
>
> "Jason" wrote in message
> > > Hello, is it possible to order by a measure in the cube?
> >
> > Pivot tables let you sort by a measure, but I would like set the default
> > sort for a particular measure on the server.
> >
> > Thanks,
> > Jason
> > http://www.stockpickbloggers.com > >> Stay informed about: Order by Measure
Using a hidden measure in a calculated measure - I have a measure group with two facts, one of those with visibility set to False. However, when using that hidden fact in a calculated member, I receive an error when trying to open up the cube. The fact on it's own really makes no sense and I'd like...
Total row by measure - Hi, Consider the following MDX Query: SELECT {[Measures].AllMembers} ON COLUMNS, {([DimDate].[2007].[3].[1]:[DimDate].[2007].[3].[29])} ON ROWS FROM [MyCube] This query returns rows with the values of each measure per day (29 days, 29 rows).....
Measure Properties - WHY i can ask for some properties and.. - My Question: i can ask for some measure properties like ID and NAME, exaample: [Measures].[StandardPrice].Properties("ID") but i cant ask for the properties "Description" or "Data Type". Is there any way to do that?? We ne...
Measure with aggreagation None ...... - I have a measure that can't be aggregated (forecasted average item price per month per productgroup), only values calculated based on this measure can be calculated. I have set its Aggreagatefunction to none. But when i'm browsing the cube and go down t...
Measure calculation question - Hi all, I am trying to perform a calculation which is causing me a headache because I can't write MDX! :( - any help would be appreciated here. Basically, I have the following scenario of data: Date Product Value Qty1 Qty2...
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
