Hi All,
I realize that there are countless postings on Matrix totals, but I haven't
found a posting that specifically relates to what I'm trying to accomplish.
What I want to do is reference the calculated totals from one matrix in
another matrix. I don't know if this is even possible, but here's the what
I'm aiming for:
DATE Total Dept. 1 Dept. 2 Dept. 3 .....
Jan. 01 8 1 4 3
Jan. 02 10 2 3 5
Jan. 03 11 3 6 2
...
Jan. 31 9 2 2 5
---
MTD 38 8 15 15
Target 45 15 15 15 .....
Prev. Mon.51 14 18 19
Diff. -13 -6 -3 -4
Perc. 74.5% 57% 83% 78.9%
The MTD row is the Month To Date total for the first matrix (calculated
automatically using 'Subtotal'). Below that is the second matrix used to show
statistics. The reason I'm using a second matrix is because the number of
Departments is not a constant, so the bottom matrix needs the same number of
columns as the top matrix. (I'm using the same criteria for the "Columns",
and then just hiding it.)
The problem is, for the calculations in the bottom matrix, I need to know
the individual totals in each MTD cell in the above matrix, not just the
grand total. Is it possible to access those fields from the expression of a
cell in the bottom matrix (I.E. use the MTD total for Dept. 2 to calculate
the difference between the current month and the previous month in the lower
matrix)?
If not, then that leads me to believe I have the wrong approach to this
problem, and if that's the case, then how else would this be achieved?
Thanks very much in advance.
Martin McCarthyHas anybody come across a situation like this before? Any input would be
appreciated.
Thanks,
Martin
"Joseph Rea, Accord Software" wrote:
> Hi All,
> I realize that there are countless postings on Matrix totals, but I haven't
> found a posting that specifically relates to what I'm trying to accomplish.
> What I want to do is reference the calculated totals from one matrix in
> another matrix. I don't know if this is even possible, but here's the what
> I'm aiming for:
> DATE Total Dept. 1 Dept. 2 Dept. 3 .....
> Jan. 01 8 1 4 3
> Jan. 02 10 2 3 5
> Jan. 03 11 3 6 2
> ...
> Jan. 31 9 2 2 5
> ---
> MTD 38 8 15 15
>
> Target 45 15 15 15 .....
> Prev. Mon.51 14 18 19
> Diff. -13 -6 -3 -4
> Perc. 74.5% 57% 83% 78.9%
>
> The MTD row is the Month To Date total for the first matrix (calculated
> automatically using 'Subtotal'). Below that is the second matrix used to show
> statistics. The reason I'm using a second matrix is because the number of
> Departments is not a constant, so the bottom matrix needs the same number of
> columns as the top matrix. (I'm using the same criteria for the "Columns",
> and then just hiding it.)
> The problem is, for the calculations in the bottom matrix, I need to know
> the individual totals in each MTD cell in the above matrix, not just the
> grand total. Is it possible to access those fields from the expression of a
> cell in the bottom matrix (I.E. use the MTD total for Dept. 2 to calculate
> the difference between the current month and the previous month in the lower
> matrix)?
> If not, then that leads me to believe I have the wrong approach to this
> problem, and if that's the case, then how else would this be achieved?
>
> Thanks very much in advance.
> Martin McCarthy
Showing posts with label realize. Show all posts
Showing posts with label realize. Show all posts
Wednesday, March 7, 2012
Saturday, February 25, 2012
Reducing Database Size (contains images)
Hello. I am wondering how to effectively reduce the size of my database. After viewing the individual table sizes, I have come to realize that nearly 99% of the database's size is due to images. I am told that too much binary data is not good. How can I go about reducing the size of my database (possibly the images themselves)? I'd appreciate any help.store the path and filename instead of the image?
Do you use READTEXT WRITETEXT alot?
what's the size of a average image?|||The average size is around 680k. I do not use readtext and writetext a lot. How do i go about storing the path instead of the actual image?|||Someone suggested a UNC path to the images. What is this?|||UNC = Universal Naming Convention
\\servername\sharename\pathname\filename.img
so you can place the images anywhere|||is there an easy way to do this if I have around 360 images that need to be moved? What do i put in the table's data field|||UNC=\\SERVER\SHARE\FILENAME.EXT
There are kudos of reasons to store images in the database itself. It all depends on the app itself, and what is actually stored in those images. I prefer to use image and (n)text fields, because that's what a database is for. And if there is anything that is associated with the business through your app, - its place is in the database. The question comes how this info is being used. For example, in healthcare industry it becomes more and more practical to do high-speed scanning of claims. Scanned images are burned onto media of choice. Some organizations are also storing those images into database (TIFF format), others go even further and apply OCR technology to avoid data entry process. Key elements of the claim image are stored in related tables to meet search needs. The only time the image field is accessed is when there is a need to view the original claim. Will it make sense to store a path to a TIFF file instead of the file itself? Does the database have any control over OS environment? NO!!! In other cases Full-Text Search capability is used if the type of file being stored meets the parsing and filtering capabilities of the search engine (Word documents for example.) Whoever told you that "too much binary data is not good" is operating under unqualified assumptions. You need to look into the nature of the business usage of your app and determine whether it does or does not make sense to rely on database for safe-keeping of your images (I think the answer is pretty clear, hey?!)|||And the debate starts again...
If you have significant volume...I'd say it's an issue...
Hell they went out and bought kodak imagining platter to handle everything...it's massive...
no way a db could handle this volume...
There's also the pain of reaind and writing in chunks (how do you update a chunk again? Is it the whole thing?)
How big are the images?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36026|||He told you, - 680K|||My problem is that the database itself is far too large, and it is 99% due to these images. They are simply photos of employees and there are around 360 of them. We use them on a web site where once a name is typed in, info about that person is displayed; background info, history with the company, sales numbers, the photo, etc. How do i go about creating this UNC to the images? Where do you recommend i save this pictures? I appreciate any help.|||So, are we talking about less than 250MB worth of images? If this size is taken by 1% of your structure, then your database is less than 500MB all together. Why are you concerned about this? Why are you calling it "a problem?"|||What is far too large?
If the pix are 1 mb you only be saving 360 mb
That's not big
Do you use READTEXT WRITETEXT alot?
what's the size of a average image?|||The average size is around 680k. I do not use readtext and writetext a lot. How do i go about storing the path instead of the actual image?|||Someone suggested a UNC path to the images. What is this?|||UNC = Universal Naming Convention
\\servername\sharename\pathname\filename.img
so you can place the images anywhere|||is there an easy way to do this if I have around 360 images that need to be moved? What do i put in the table's data field|||UNC=\\SERVER\SHARE\FILENAME.EXT
There are kudos of reasons to store images in the database itself. It all depends on the app itself, and what is actually stored in those images. I prefer to use image and (n)text fields, because that's what a database is for. And if there is anything that is associated with the business through your app, - its place is in the database. The question comes how this info is being used. For example, in healthcare industry it becomes more and more practical to do high-speed scanning of claims. Scanned images are burned onto media of choice. Some organizations are also storing those images into database (TIFF format), others go even further and apply OCR technology to avoid data entry process. Key elements of the claim image are stored in related tables to meet search needs. The only time the image field is accessed is when there is a need to view the original claim. Will it make sense to store a path to a TIFF file instead of the file itself? Does the database have any control over OS environment? NO!!! In other cases Full-Text Search capability is used if the type of file being stored meets the parsing and filtering capabilities of the search engine (Word documents for example.) Whoever told you that "too much binary data is not good" is operating under unqualified assumptions. You need to look into the nature of the business usage of your app and determine whether it does or does not make sense to rely on database for safe-keeping of your images (I think the answer is pretty clear, hey?!)|||And the debate starts again...
If you have significant volume...I'd say it's an issue...
Hell they went out and bought kodak imagining platter to handle everything...it's massive...
no way a db could handle this volume...
There's also the pain of reaind and writing in chunks (how do you update a chunk again? Is it the whole thing?)
How big are the images?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36026|||He told you, - 680K|||My problem is that the database itself is far too large, and it is 99% due to these images. They are simply photos of employees and there are around 360 of them. We use them on a web site where once a name is typed in, info about that person is displayed; background info, history with the company, sales numbers, the photo, etc. How do i go about creating this UNC to the images? Where do you recommend i save this pictures? I appreciate any help.|||So, are we talking about less than 250MB worth of images? If this size is taken by 1% of your structure, then your database is less than 500MB all together. Why are you concerned about this? Why are you calling it "a problem?"|||What is far too large?
If the pix are 1 mb you only be saving 360 mb
That's not big
Subscribe to:
Posts (Atom)