hexagon logo
Register Sign in
  • Replies 17 replies
  • Subscribers 9 subscribers
  • Views 400 views
  • Users 0 members are here
Options
Related

Automate Generating Reports

acgarcia
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


  • 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.
Reply


  • 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.
Children
  • 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.
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement