Doubt in crosstab

I am using one dataset to create two datacubes

Please check my attach report.( I am working using java event handler)

Note: "AUH-..." are node name
"SR7" are node type

on the first crosstab, the port details are displayed based on unique node name and node type

on the second cross tab, the details are displayed based on unique NODE TYPE.

for the second crosstab, the total ports and freeports are perfect, but the "percentfree" is wrong. It is taking the value from the dataset but i want that it should take the value from the measure "totalports1" and "freeports1" and then print the calculated value in the "percentfree1"

How this can be done ?

Find more posts tagged with

Comments

mwilliams

Hi Happy_20,

So, you're taking the percentFree value from the dataSet, but it's wrong? So, you want to calculate it instead?

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73241" data-time="1297445815" data-date="11 February 2011 - 10:36 AM">
Hi Happy_20, 
 
So, you're taking the percentFree value from the dataSet, but it's wrong? So, you want to calculate it instead? </blockquote>

Happy_20

Thanks a lot for your quick reply.

Yea i need to calculate percent free based on the other two measures "totalports1" and "freeports1"
in percentfree1, i need to write expression as " freeports1/totalports1 *100 "
Since freeports1 and percentfree1 are not in data set , im not able to write the above expression

mwilliams

If freeports1 is not in the database, how do you plan to calculate the percentage?

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73251" data-time="1297452496" data-date="11 February 2011 - 12:28 PM">
If freeports1 is not in the database, how do you plan to calculate the percentage? </blockquote>
 
There is one dataset called "portdetails" that has "node","type","cardtype","totalports","freeports","percentfree" 
 
There are two data cubes called "Network summary" and "Portsummary" that uses the same dataset "portdetails" 
 
"PortSummary" gives the details based on "node" and "type" 
"NetworkSummary" gives the details based on "type" 
 
As you see in the file(the latest one), the 1st crosstab that is "portsummary" is displayed perfectly fine. 
 
For "NetworkSummary" , when i add "totalports" and "freeports" in the Summary Field from the "portdetails" dataset, it works fine. 
But, for calculating "percentfree", it is not giving the desired output.

mwilliams

Can you attach some data how it appears in your dataSet and then show what you want it to look like in your report. I'll just test on it a little.

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73260" data-time="1297458814" data-date="11 February 2011 - 02:13 PM">
Can you attach some data how it appears in your dataSet and then show what you want it to look like in your report. I'll just test on it a little. </blockquote>
 
I am attcahing the eventhandler, java bean, report and the mock data file that I am using in a zip 
 
I am also attaching the sample report (so that you can have idea of what I am looking for). In that, the way "% free" is displayed (Network summary), the same way i want in my report.

mwilliams

I actually meant just a simple CSV file of data the way it is in your dataSet. That's the easiest way to put this together quickly to test. You can just paste some data in here out of your dataSet and I'll make a CSV file or you can make the CSV file and attach it. Whatever works best. Thanks!

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73265" data-time="1297462626" data-date="11 February 2011 - 03:17 PM">
I actually meant just a simple CSV file of data the way it is in your dataSet. That's the easiest way to put this together quickly to test. You can just paste some data in here out of your dataSet and I'll make a CSV file or you can make the CSV file and attach it. Whatever works best. Thanks! </blockquote>
 
I have sent you a *mockgenerator.java that has all the data that is in my dataset. If you see my report and the mentioned file, you will find that both the data are same

Happy_20

<blockquote class='ipsBlockquote' data-author="'Happy_20'" data-cid="73266" data-time="1297473501" data-date="11 February 2011 - 06:18 PM">
I have sent you a *mockgenerator.java that has all the data that is in my dataset. If you see my report and the mentioned file, you will find that both the data are same </blockquote>
 
Hi Micheal, 
 
Are you able to figure out what i am looking for or do I need to explain more ? 
 
Thanks

mwilliams

I don't have the library that you're getting your dataSource and dataSet from. I think that might be causing a problem because I'm getting no data and getting an error about script used in the report, but according to the report outline, there is no script on the report. Not sure what's going on here.

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73317" data-time="1297719568" data-date="14 February 2011 - 02:39 PM">
I don't have the library that you're getting your dataSource and dataSet from. I think that might be causing a problem because I'm getting no data and getting an error about script used in the report, but according to the report outline, there is no script on the report. Not sure what's going on here. </blockquote>
 
Hey 
 
I figured out the issue. 
Thanks a lot for your quick and active support.

mwilliams

Ah. Glad you figured it out! What was the issue you ended up having? Let us know whenever you have questions!

Happy_20

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="73395" data-time="1297810264" data-date="15 February 2011 - 03:51 PM">
Ah. Glad you figured it out! What was the issue you ended up having? Let us know whenever you have questions! </blockquote>
 
I was looking to work on "derived measure" and i was not knowing that the calculated columns in measures are called as "derived measures". So, finding it hard to explain you. Finally looked up, that you have given same solution to someone and voila got it

mwilliams

Ah. I had assumed that you were already using the derived measure since the percentage was working in the first crosstab. That's my bad for assuming.

Like I said before, let us know whenever you have questions!