Automate Generating Reports

Good Morning:

I've searched the forum but didn't find what I was looking for. Is there a way to automate generating reports in datapage? In know you can save queries with a specific date range. I can just update the date range for what i'm looking for. My problem is that the tolerances for the features are different. 0.001-0.015". From my experience, with using a saved query, it doesn't keep individual tolerances. So all features are 0.001 or 0.005 or 0.010 and so on.

Parents

Kp61dude! over 6 years ago

Yes.

When DataPage imports an XML, there are some values that are hidden and cannot be changed. One of them is for when you select the option to "Use calculated bonus tolerance" (or something to that effect). But, in the variables there are values like DF.B and TP.B. If you change those values, the calculated bonus tolerance doesn't change. So, the report will still show a TP of, for example, 1.100, for a 1.000 TP plus 0.100 bonus from feature. So, change the DF.B and TP.B to something like 0.200 and the calculated TP on the report is still 1.100.

The value used is hidden, somewhere, that the DP front end cannot edit.

So, i was just curious, before downloading, installing and spending any time looking, if I could use your experience. If it's possible, that would be a huge boon. Instead of having to delete transactions, and modify the XML file, and re-import the files, I could just open the Visual Studio, modify it, and go back to DP and be done.

Yeah pretty sure you can modify the DF.B and TP.B and DataPage would have no other choice but to read in those values.

Came across these guys In the DB:

dbo.Variable
SID	Dimension_SID	Variable_Name	Variable_Type	Distributor_Type	Description
278	145	X	1202	NULL	NULL
279	145	Y	1203	NULL	NULL
280	145	DF	1206	NULL	NULL
281	145	DF.B	NULL	NULL	NULL
282	145	TP	1209	NULL	NULL
283	145	TP.B	NULL	NULL	NULL
284	145	B	1209	NULL	NULL
285	145	B.B	NULL	NULL	NULL

I would say give it a shot, you won't waste your time. You can PM me anytime for help.

You can write a script to run a .sql file, I'm sure, and fire it before you look at DP.

How would I go about replicating your scenario? I will modify them and report back what DP shows.

VinniUSMC over 6 years ago in reply to Kp61dude!

Those values, at least modified via DataPage, do not affect the TP tolerance that is calculated.

Any (legacy) TP dimension you send from PC-DMIS to DataPage (I use the DataImporter with XML) that has MMC selected. Then in DataPage Tools>Options, select the "Include Bonus Tolerance" option. If you have Tolerances shown on the Data Editor tab, you can see what happens in DataPage.

Using my earlier example, a hole that gives 0.100 bonus tolerance when imported into DataPage with 1.000 TP, will then show 1.100 tolerance. If you change ANY of those values (DF.B, TP.B, B, or B.B) the TP value will still show 1.100. If you change the TP tolerance to 0.500, it will auto-calculate and show 0.600. It will always maintain that 0.100 MMC value, somewhere.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

VinniUSMC over 6 years ago in reply to Kp61dude!

Those values, at least modified via DataPage, do not affect the TP tolerance that is calculated.

Any (legacy) TP dimension you send from PC-DMIS to DataPage (I use the DataImporter with XML) that has MMC selected. Then in DataPage Tools>Options, select the "Include Bonus Tolerance" option. If you have Tolerances shown on the Data Editor tab, you can see what happens in DataPage.

Using my earlier example, a hole that gives 0.100 bonus tolerance when imported into DataPage with 1.000 TP, will then show 1.100 tolerance. If you change ANY of those values (DF.B, TP.B, B, or B.B) the TP value will still show 1.100. If you change the TP tolerance to 0.500, it will auto-calculate and show 0.600. It will always maintain that 0.100 MMC value, somewhere.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

No Data