Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Formatting a dimension

  
   Database Help (Home) -> OLAP RSS
Next:  Am unable to take the screen shot of the report.p..  
Author Message
Michael G. Schneider

External


Since: Dec 03, 2008
Posts: 23



(Msg. 1) Posted: Tue Dec 09, 2008 4:25 am
Post subject: Formatting a dimension
Archived from groups: microsoft>public>sqlserver>olap (more info?)
With SQL server 2005.

There is a FormatString propety for measures. I cannot find the same for
dimensions. Doesn't it exist?

Michael G. Schneider

 >> Stay informed about: Formatting a dimension 
Back to top
Login to vote
Michael G. Schneider

External


Since: Dec 03, 2008
Posts: 23



(Msg. 2) Posted: Tue Dec 09, 2008 4:25 am
Post subject: Re: Formatting a dimension [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Ohjoo Kwon" schrieb im Newsbeitrag


> No, it does not.

Thanks a lot for this answer.

Michael G. Schneider

 >> Stay informed about: Formatting a dimension 
Back to top
Login to vote
Michael G. Schneider

External


Since: Dec 03, 2008
Posts: 23



(Msg. 3) Posted: Tue Dec 09, 2008 6:25 am
Post subject: Re: Formatting a dimension [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Michael G. Schneider" schrieb im Newsbeitrag

> "Ohjoo Kwon" schrieb im Newsbeitrag
>
>
>> No, it does not.
>
> Thanks a lot for this answer.

With MS SQL Server 2005, MS Excel 2007.

There is a date column in the fact table. I want to define a drillthrough
action, so the date column is displayed in Excel as a true date.

I tried various alternatives, but it just won't work. Should this be
possible? How?

Michael G. Schneider
 >> Stay informed about: Formatting a dimension 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Formatting Dimension Attribute - I easily found out how to format my dollar values in my measures as currency - can I not do the same in my dimension attributes as easily? I want to convert one of my Date's from displaying in cube as: 2008-04-11 00:00:00 to 04/11/2008

Dimension from Dimension - Can I create a dimension in OLAP by using an existing dimension and measure in OLAP?

Dimension design help please - Hi, I am new to the OLAP system. I need to design an account dimension, it includes lots of leaf members and levels. The problem is I can not use parent-child dimension, because some leaf members are included in multiple levels. - Sum 1 |---Sum 11 | ...

ParentChild Dimension Help - Hi All, I am trying to build a Parent-Child Dimension. In addition to Parent-Child heirarchy, there is additional LeveL heirarchy in my table: example -- ChildId, ChildName, ParentId, LevelName 1, 'SA', null, 'Top' 2, 'A', 1, 'Level2' 3, 'B', 3,..

Fact / Dimension - I'm putting together the model using Kimball templates on our small system here at work. it's a contracts tracking system of sorts - where a contractor get's awarded a contract. A contract has 1 to many ammendments through it's cycle, and there is...
   Database Help (Home) -> OLAP All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 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



[ Contact us | Terms of Service/Privacy Policy ]