Friday, June 19, 2009

Tweaking OLAPCell and OLAPDataGrid to display custom formatted values

Displaying custom formatted data in OLAPDataGrid is a bit tricky because OLAPDataGrid doesn't use the OLAPCell.formattedValue at all due to a bug in its implementation.

However the tweaks I am going to mention are simple and can be used to get this to work. After the tweaks don't forget to build the datavisualization.swc using the steps I have described in one of the earlier posts.

Modifing OLAPCell.as file : Modify the constructor to set a formatted value into the _formattedValue property

public function OLAPCell(value:Number, formattedValue:String=null)

{

_value = value;

_formattedValue = insert any custom formatting logic using value ;

}

Modify OLAPDataGrid.as : Somewhere around line 769 we can find the following line

label = cell && !isNaN(cell.value) ? String(cell.value) : defaultCellString;

Modify this to read as follows

label = cell && !isNaN(cell.value) ? String(cell.formattedValue) : defaultCellString;

Build the swc and use it in your app to get custom formatting. Of-course some more tweaking it required to make this generic and supply a Flex formatter directly to OLAPDataGrid. I am sure it can be easily figured out !

27 comments:

MENDONÇA said...

miHow can I have the sources of datavisualization.swc to change the class and OLAPDatagrid.as OLAPCell.as and compile again? Contents I could the way to do the test .... thanks

Sreenivas said...

I have explained where to find the source here

And how to build it after making changes here

MENDONÇA said...
This comment has been removed by the author.
MENDONÇA said...

Sreenivas
would make the formatting of the values of type pivotcomponent with olapdatagrig, simple ..?

NumberFormatter id="fmtNumber" precision="2"

Nancy said...

I know this is way off subject, but here goes..

I'm having some really weird issues with populating an advanceddatagrid with xmlList (quoteXMLList) data. Here is my situation. I've got an xmllist that, when looking at one entry (xmlList[0]), has xml looking like this.

[response]
[cost]
[totalCost]20[/totalCost]
[/cost]
[/response]

Now I'm trying to get totalCost as a datafield and for it to show up in a adg column. So I tried something like this

[mx:AdvancedDataGrid editable="false" width="100%" height="100%" variableRowHeight="true" id="quoteDataGrid" dataProvider="{this.quoteXMLList}"]
[mx:columns[
[mx:AdvancedDataGridColumn dataField="cost.totalCost" headerText="Total Cost" /]

But nothing shows up. So, I changed my dataprovider to this.quoteXMLList.cost and put dataField="totalCost" and it shows up fine. But I can't do that cause I have more info I need to gather for other columns that is in different areas of the xml in the current xmlList. So, can you not put e4x notation in datafield, if not what do I do here? Thanks in advance.

Sreenivas said...

You can try using what is described here http://flexpearls.blogspot.com/2008/01/extending-dgcolumn-and-adgcolumn-to.html or use a custom itemRenderer for that column and access and display the 'totalCost' field using the data member.

Unknown said...

For people who are part of tertiary education it comes as no secret that any overview requires passing judgment upon given information. If you look for someone who would write dissertation proposal as good as papersmart quickly for your college professor come to our online service. We employ only educated people with good skills and bright brains aware of many serious scientific features of any kind of problem of a modern life.

johnewicks said...

Unbelievable post to Gain a lot of knowledge, Require on the d best Ph.D. writing service assistance excellent assignment assistance among most university students. 25 percent OFF On each single. best phd writing service

Tech Line US Reader said...

This is really a great stuff for sharing. Keep it up .Thanks for sharing. https://howtoupdatedrivers.net/hp-deskjet-3510-driver/

KarenHill said...



I found this is an informative and interesting blog so I think so it is very useful and knowledgeable to quality essay

Bark Rokli said...

Digital media is currently the most effective way for brands to reach their consumers on a daily basis. Web Agency In Dubai

Bark Rokli said...

Substantial disagreement exists concerning how designers in many fields, whether amateur or professional, alone or in teams, produce designs. Best Cleaning Company In Dubai will give you the most extra free hours to spend on more enjoyable things.

Jeny Jehn said...

From a less technical perspective, a writer on etiquette in the early 20th century defined conversation as the polite give and take of subjects thought of by people talking with each other for company. Mobile App Development Dubai I take every software & platform into consideration to make sure my help is available for any sort of requirement.

jasmine said...

Awesome Post App developer thanks for sharing

Law Assignment said...

With the increase in demand for the subject, Australia Legal Assignment Help has come up with specialist writers undertaking Competition and Consumer Law Assignment with the expansion of commercial subjects related to consumer grievances, commodity satisfaction costing and impartial competition, the aforementioned dynamic topics have all assumed great deal of value and importance which is showed in variety of laws which the law makers have made, so as to preserve the rights of the consumers. This is obviously a welcome announcement for the consumers and the students, nonetheless this also implies researching on vast variety of topics and contents.

Assignment help said...

Innovation Management Assignment Help ,
Time Value Of Money Assignment Help ,
Compensation Management Assignment Help ,
Organization Development Assignment Help ,
Business Assignment Help ,
Corporate Culture Assignment Help ,
Marketing Assignment Help ,
Strategic Marketing Assignment Help ,


Assignment help said...

Thanks for sharing this post
Business Law Assignment Help
Business Law Essay Assignment Help
Business Law essay
Business Law help
Business Law Homework
Business Law term paper

Law Assignment said...

Our Contract Law Assignment Help is supported up by learned essayists who ensure 100% unique work. Each Contract law assignment and exposition experiences three checks – after composing, altering and editing utilizing literary theft checker – valid unoriginality recognizing programming. In this way, you can be guaranteed of a literary theft free arrangement each time you submit a request.

Contracts Law Essay Assignment
contract law essay
contract law assignment help
contract law dissertation
contract law coursework
contract law expert
contract law Australia

Law Assignment said...

Australialegalassignmenthelp.com is known worldwide for its excellent quality Business Law Assignment Help services and affordable rates. Many of students have trusted our writing services throughout their academic years. Business Law Essay Assignment Help is one of the best services that Australialegalassignmenthelp.com can offer to law student
Business Law Assignment Help
Business Law assignment
Business Law help
Business Law Homework
Business Law term paper
Business Law thesis
Business Law coursework

Abbie Wright said...

Dear admin, I am not comment any article and forum post but after reading your this blog, I am compelled to write here comment. Thankyou so much for posting this topic information. I just want to let you know that I just check out your site many others posts and I find it very interesting and useful info here. I can't wait to read lots of your posts, Please shared some more posts with us. Australia Assignment Help - best assignment help in brisbane - best assignment help in perth - Online Assignment Help

Abbie Wright said...

Thankyou so much admin for posting this topic content. It is very educational and helpful to anyone. You may remark on the request arrangement of the niche post. Your website each release review would swell up your readers. Again thank you for sharing this article, I am waiting your response. Good luck and have a nice day admin. make my assignment - coursework help - psychology assignment help

Leo Oliver said...

Superb Post! Commercial Law Assignment analyzes economic issues and makes ideas based on the expertise of accounting, finance, management, human resources, and other business professionals. Assignmenthelped, a reputable website, can aid you with the best online Law Assignment help. Our team of professionals can assist you with your commercial law assignment. Commercial Law Assignment Help

Full Assignment - Online Assignment Help said...


Hello, thanks for sharing such pretty informing blogs
Full assignment help Call us +44-7451282508 If You Looking For online assignment help Get assignment helper from experts at the affordable prices You get the work done with various benefits at the best market cost.

Assignment helper said...

Nice post online assignment help croydon

Hazel D. Charest said...

OLAPCell, OLAPDataGrid, custom formatted values, display, tweaking

In the world of data analysis and reporting, displaying data in a visually appealing and easily understandable format is crucial. This is where the power of OLAPCell and OLAPDataGrid comes into play. These tools provide a flexible framework for manipulating and presenting data in an organized manner.

One of the key advantages of using OLAPCell and OLAPDataGrid is the ability to customize the formatting of values displayed. This means that you have full control over how your data is presented to end-users. Whether it's currency symbols, decimal places, or specific date formats, you can tweak these tools to meet your exact requirements.

By leveraging the capabilities of these tools, you can create visually stunning reports that not only convey information effectively but also leave a lasting impression on your audience. With just a few tweaks to the formatting options available in OLAPCell and OLAPDataGrid, you can transform raw data into meaningful insights that drive informed decision-making.

So if you're looking for a way to enhance the visual appeal and user experience of your data analysis reports, look no further than tweaking OLAPCell and OLAPDataGrid to display custom formatted values. Unlock their full potential and take your reporting capabilities to new heights. Most students are drawn to these types of articles and information, but they are unable to prepare for their exams, If you have been struggling with your exams and want assistance, students can pay professional test takers for hire and get higher grades on their examinations by providing them with the most okay available resources, including quality academic services.

Start My Online Class said...

One of the key advantages of using OLAPCell and OLAPDataGrid is the ability to customize the formatting of values displayed. This means that you have full control over how your data is presented to end-users. Whether it's currency symbols, decimal places, or specific date formats, you can tweak these tools to meet your exact requirements. Most students are drawn to these types of articles and information, but they are unable to prepare for their exams, If you have been struggling with your exams and want assistance, students can pay someone to do my online class and get higher grades on their examinations by providing them with the most okay available resources, including quality academic services.

One Digital Stop said...

In the world of data analysis and reporting, displaying data in a visually appealing and easily understandable format is crucial. This is where the power of OLAPCell and OLAPDataGrid comes into play. These tools provide a flexible framework for manipulating and presenting data in an organized manner.
Most students are drawn to these types of articles and information, but they are unable to prepare for their exams, If you have been struggling with your e-commerce project and want assistance, students can visit ecommerce web design company and get the best performance on their website by providing them with the most excellent available resources, including quality web design services.