How to create delivery conditions for specific values?
D
Dhilip Ramesh
started a topic
over 8 years ago
I am bursting a document using InfoBurst that contains the count of a table after the end of an ETL job. I want to burst the doc only under the following conditions:
Gecko Metric IN BUGCOUNT;BRXCOUNT
Variance GREATER THAN 0.30%
I have tried bursting them creating various delivery conditions and it doesn't burst. When I burst without any conditions it easily bursts out the doc.
IMAGE ATTACHED
I tried using Excel but I am not sure how to select the cell range. Gecko Metric values are in C column and Variance values are in F column.
Could someone help me out with this since I am unable to find an answer from the existing Solutions on the site.
Whenever I set up a delivery condition based off of data within the report I first deliver the report as Excel.Then I pinpoint the exact cell I am basing my condition.
For example, let's say that I am going to send a report conditionally based off of revenue and the value is placed in cell C7. I would like to only send when the value is greater than 10000.
Attached video is how I would accomplish this. Apologies for the hidden mouse pointer. If you have any questions please let me know.
Whenever I set up a delivery condition based off of data within the report I first deliver the report as Excel.Then I pinpoint the exact cell I am basing my condition.
For example, let's say that I am going to send a report conditionally based off of revenue and the value is placed in cell C7. I would like to only send when the value is greater than 10000.
Attached video is how I would accomplish this. Apologies for the hidden mouse pointer. If you have any questions please let me know.
Dhilip Ramesh
I am bursting a document using InfoBurst that contains the count of a table after the end of an ETL job. I want to burst the doc only under the following conditions:
Gecko Metric IN BUGCOUNT;BRXCOUNT
Variance GREATER THAN 0.30%
I have tried bursting them creating various delivery conditions and it doesn't burst. When I burst without any conditions it easily bursts out the doc.
IMAGE ATTACHED
I tried using Excel but I am not sure how to select the cell range. Gecko Metric values are in C column and Variance values are in F column.
Could someone help me out with this since I am unable to find an answer from the existing Solutions on the site.
Hello Dhilip,
Whenever I set up a delivery condition based off of data within the report I first deliver the report as Excel.Then I pinpoint the exact cell I am basing my condition.
For example, let's say that I am going to send a report conditionally based off of revenue and the value is placed in cell C7. I would like to only send when the value is greater than 10000.
Attached video is how I would accomplish this. Apologies for the hidden mouse pointer. If you have any questions please let me know.
-Bryan
Bryan Downing
Hello Dhilip,
Whenever I set up a delivery condition based off of data within the report I first deliver the report as Excel.Then I pinpoint the exact cell I am basing my condition.
For example, let's say that I am going to send a report conditionally based off of revenue and the value is placed in cell C7. I would like to only send when the value is greater than 10000.
Attached video is how I would accomplish this. Apologies for the hidden mouse pointer. If you have any questions please let me know.
-Bryan
- 
										
											How do I achieve load balancing using BI 4.x WACS?
										 
									 - 
										
											What is the best way to suppress delivery of empty reports?
										 
									 - 
										
											Event Based Schedule Running Past Midnight
										 
									 - 
										
											Best practice to create a burst with production and development version of documents
										 
									 - 
										
											attach an exisiting PDF document to Burst report
										 
									 - 
										
											Delivery to a Cloud Drive
										 
									 - 
										
											Standard Query
										 
									 - 
										
											How to apply Delivery condition while using Infoburst Content Grouping By Burst?
										 
									 - 
										
											Parameters for IBShell Scripts
										 
									 
See all 28 topics