Formating date in Data Analysis view for PWA 2007

[kahuna]

PWA 2007 Data Analysis View gurus, please advise. Any way we could change the
days to show up as actual days (Sun 11, Mon 12) instead of Day 11, Day 12
etc?

 

[Dale Howard [MVP]]

Kahuna --

No, sorry, but this is not possible. You would have to manually edit the
Caption property of EVERY day, which would be a very laborious process that
I doubt you would want to do. Hope this helps.

 

[Stuart Penning]

Kahuna, I faced this issue a while ago and the only sollution I found other than what Dale suggested is to build your own OLAP cube.

Editing the existing cubes is possible but unfortunately, making the changes persist is a bit of a problem because as far as I can tell, the cubes are auto-generated and this feature could erase any changes you make.

So, that is what I did - I created an OLAP cube of my own, using Analysis Services. This cube has custom time dimension which shows the time data in precisely the way I want and it works like a dream.

My opinion is that Microsoft has done us all a very important service with the new reporting database and making an investment in a custom Cube, using SQL Server Analysis Services is well worth it.



kahuna wrote:

Formating date in Data Analysis view for PWA 2007
29-Mar-10

PWA 2007 Data Analysis View gurus, please advise. Any way we could change th
days to show up as actual days (Sun 11, Mon 12) instead of Day 11, Day 1
etc?

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Measuring SharePoint Page Rendering
http://www.eggheadcafe.com/tutorial...1-9d5f236c2be5/measuring-sharepoint-page.aspx

 

[leo]

Hi, Stuart Penning,
Can u tell me detail how to do it what u said? Coz i
also need that way urgently to make customize the date show in analysis view.
Thanks.


Regards,
leo

 

[Robert]

Hi Stuart,

I'm also very interested in this possibility of creating a custom Cube in
Analysis Services.
Could you detail the process to do that?
Thanks

Robert

 

[Stuart Penning]

Robert, Leo
I would be happy to help but you need to consider how this cube will be maintained. Once you have the basic customisations you need, there will be a slew of requests - take my word for that.
The first thing to do is to assess what you have in terms of resources. Do you have Visual Studio 2005/2008? Do you have anyone on staff or available to you that can maintain the custom cube for you? etc.
There is an alternative, which is not as pretty but it works (the results are much the same) and its inexpensive - that is to use the Pivot Tables in Excel.
Send me an email and I'll help you get what you need.
Stuart




Robert wrote:

Hi Stuart,I am also very interested in this possibility of creating a custom
30-Mar-10

Hi Stuart

I am also very interested in this possibility of creating a custom Cube i
Analysis Services
Could you detail the process to do that
Thank

Rober

(e-mail address removed)...

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk: Conditional looping incorporating the Greater Than functoid.
http://www.eggheadcafe.com/tutorial...2d-043c18df964c/biztalk-conditional-loop.aspx

 

[Lars Hammarberg]

Caveat: I haven't tested this for more than a few rebuilds of the olap cube
in my test system, but so far it doesn't seem to have broken anything...

If you look at the view MSP_TimeByDay_OlapView in the reporting database,
you'll find that the field 'CalendarMemberNameDay' is composed of the
following formula:

'Day' + CONVERT (CHAR, TimeDayOfTheMonth)

Now, if you modify that formula to this:

LEFT(DATENAME(weekday, TimeDayOfTheMonth),3) + ' ' + CONVERT (CHAR,
TimeDayOfTheMonth)

you'll get the desired results

 

[Ben Howard [MVP]]

Lars, what a brilliant tip. Thanks.

 

[Stuart Penning]

http://blogs.msdn.com/seanday/archi...e-hierarchy-in-project-server-2007-cubes.aspx



Ben Howard [MVP] wrote:

Lars, what a brilliant tip. Thanks.--Regards, Ben.http://www.applepark.co.
31-Mar-10

Lars, what a brilliant tip. Thanks
-
Regards, Ben

http://www.applepark.co.u
http://appleparkltd.spaces.live.com

:

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Featured Product / Service Review: TekPub
http://www.eggheadcafe.com/tutorial...2e-39384482c80e/featured-product--servic.aspx