| 
| Welcome, Guest |  
| You have to register before you can post on our site. 
 
 |  
 
 
 
| Latest Threads |  
| What is the maximum numbe... Forum: BDB Designer Q & A
 Last Post: sariga.vr@bdb.ai
 12-28-2022, 07:59 AM
 » Replies: 0
 » Views: 17,393
 |  
| Inbuilt Capability of  VC... Forum: BDB - Platform
 Last Post: shivani.jaipuria
 12-27-2022, 05:23 AM
 » Replies: 0
 » Views: 2,976
 |  
| Can  dataset/cube refresh... Forum: BDB - Platform
 Last Post: shivani.jaipuria
 12-27-2022, 05:08 AM
 » Replies: 0
 » Views: 2,833
 |  
| How to load business stor... Forum: BDB Designer Q & A
 Last Post: sariga.vr@bdb.ai
 12-26-2022, 04:47 PM
 » Replies: 0
 » Views: 5,730
 |  
| How to load business stor... Forum: BDB Designer Q & A
 Last Post: sariga.vr@bdb.ai
 12-26-2022, 04:46 PM
 » Replies: 0
 » Views: 5,266
 |  
| How to load business stor... Forum: BDB Designer Q & A
 Last Post: sariga.vr@bdb.ai
 12-26-2022, 04:45 PM
 » Replies: 0
 » Views: 4,258
 |  
| How to load business stor... Forum: BDB Designer Q & A
 Last Post: sariga.vr@bdb.ai
 12-26-2022, 04:44 PM
 » Replies: 0
 » Views: 4,262
 |  
| Data Preparation  operati... Forum: BDB-Data Prep & ETL
 Last Post: shivani.jaipuria
 12-26-2022, 10:09 AM
 » Replies: 0
 » Views: 3,248
 |  
| Plugability  Feature of B... Forum: BDB Platform Q & A
 Last Post: shivani.jaipuria
 12-26-2022, 08:32 AM
 » Replies: 0
 » Views: 2,677
 |  
| How to use environment va... Forum: BDB Platform Q & A
 Last Post: archana
 12-26-2022, 05:57 AM
 » Replies: 0
 » Views: 2,697
 |  
 |  | 
 
| What is Batch-Size? |  
| Posted by: archana  - 12-23-2022, 02:36 PM - Forum: BDB Data Pipeline Q & A 
- No Replies |  
| 
	
		
|  | 
				The pipeline components are processed in micro-batches. This batch size is given to define the number of records that we want to process in a single operation
 |  
		|   |  |  
 
| Real-time and Batch type? |  
| Posted by: archana  - 12-23-2022, 02:33 PM - Forum: BDB Data Pipeline Q & A 
- No Replies |  
| 
	
		
|  | 
				-When the Component is given as real-time the component never goes down when the pipeline is active.-When the component is given as batch then the component needs a trigger to initiate the process from the previous event. Once the process is completed and there are no new events to process the component goes down.
 |  
		|   |  |  
 
| Global Filter |  
| Posted by: Sruthi P  - 12-23-2022, 01:11 PM - Forum: BDB Business Story Q & A 
- No Replies |  
| 
	
		
|  | 
				What is global filter?
 The Global filter values are applied to all the available views created from the same datastore on a storyboard.
 |  
		|   |  |  
 
 
| Why do we use sftp reader-monitor in pipeline |  
| Posted by: archana  - 12-23-2022, 01:07 PM - Forum: BDB Data Pipeline Q & A 
- No Replies |  
| 
	
		
|  | 
				If data is present in any file (eg.excel) and we need to make a table out of that excel file in the database, we can use sftp reader- monitor combination and do the task easily.
 
 Sftp monitor ->
 
 - There are two paths, monitored path and copy path.
 - It monitors the data coming to the monitored path and cut’s and paste it to the copy path.
 - It sends only the path to the output.
 
 Sftp reader ->
 
 - It reads the data from the copy path.
 - This is dependent component, sftp reader will not work without a sftp monitor.
 |  
		|   |  |  
 
| How to get day from a date and automatically add days |  
| Posted by: archana  - 12-23-2022, 01:06 PM - Forum: BDB Designer Q & A 
- No Replies |  
| 
	
		
|  | 
				Script:-var today = new Date(d);
 var day=today.getDay();
 
 
 if(day==1)
 {
 var days5 = new Date(new Date().setDate(today.getDate() + 5));
 var full5=days5.getFullYear()+'-'+(days5.getMonth() + 1)+'-'+days5.getDate();
 sdk.setValue( 'date104',full5  );
 }
 else if((day==2)||(day==3)||(day==4)||(day==5)||(day==6))
 {
 var days6 = new Date(new Date().setDate(today.getDate() + 6));
 var full6=days6.getFullYear()+'-'+(days6.getMonth() + 1)+'-'+days6.getDate();
 sdk.setValue( 'date104',full6  );
 }
 |  
		|   |  |  
 
| To show any calculated field from tooltip |  
| Posted by: Sruthi P  - 12-23-2022, 01:03 PM - Forum: BDB Designer Q & A 
- No Replies |  
| 
	
		
|  | 
				How to show calculated field from tooltip?
 Add this in dashboard script:
 
 
 
 sdk.calculation = sdk.calculation || {};
 
 sdk.setContext( 'main33', 0 );
 
 sdk.calculation.getfiltered= function(f1, f2){
 
 if(f1 ==0){
 
 return sdk.getContext( 'main33' );
 
 }else{
 
 sdk.setContext( 'main33', Math.abs(f1-f2) );
 
 return (Math.abs(f1-f2));
 
 }
 
 };
 
 
 Add this in calculation script area:
 
 
 sdk.calculation.getfiltered(column_name );
 |  
		|   |  |  
 
 
 |