Welcome, Guest
You have to register before you can post on our site.

Username/Email:
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 56,139
» Latest member: MavisMairi
» Forum threads: 389
» Forum posts: 395

Full Statistics

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: 788
Inbuilt Capability of VC...
Forum: BDB - Platform
Last Post: shivani.jaipuria
12-27-2022, 05:23 AM
» Replies: 0
» Views: 562
Can dataset/cube refresh...
Forum: BDB - Platform
Last Post: shivani.jaipuria
12-27-2022, 05:08 AM
» Replies: 0
» Views: 528
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: 686
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: 696
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: 651
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: 633
Data Preparation operati...
Forum: BDB-Data Prep & ETL
Last Post: shivani.jaipuria
12-26-2022, 10:09 AM
» Replies: 0
» Views: 545
Plugability Feature of B...
Forum: BDB Platform Q & A
Last Post: shivani.jaipuria
12-26-2022, 08:32 AM
» Replies: 0
» Views: 535
How to use environment va...
Forum: BDB Platform Q & A
Last Post: archana
12-26-2022, 05:57 AM
» Replies: 0
» Views: 552

 
  Merge columns using calculated feilds
Posted by: Sruthi P - 12-21-2022, 04:59 PM - Forum: BDB Designer Q & A - No Replies

How to merge columns using calculated fields?

User can add fields to the datasets by merging two or more columns using calculated fields.

Ex:

((cmsn_amnt-prevcomsn)/cmsn_amnt)*100

Print this item

  Script to change background color of label
Posted by: shreekantgosavi - 12-21-2022, 03:38 PM - Forum: BDB Designer Q & A - No Replies

var division = sdk.getDivIdFromComponetId( 'label123' );

sdk.applyStyles( "#" + division + " span", { "background": "#A8AFE8"} );

Print this item

  script to change the height of dashboard
Posted by: shreekantgosavi - 12-21-2022, 03:37 PM - Forum: BDB Designer Q & A - No Replies

sdk.applyStyles("#draggablesParentDiv"+sdk.dashboard.m_id, { "height": "828px"});

Print this item

  simple script to open a another dashboard link in new window from existing dashboard
Posted by: shreekantgosavi - 12-21-2022, 03:36 PM - Forum: BDB Designer Q & A - No Replies

var a = 'https://app.bdb.ai/'

window.open(url, '_blank');

Print this item

  Script to execute a function after the timer expires
Posted by: shreekantgosavi - 12-21-2022, 03:32 PM - Forum: BDB Designer Q & A - No Replies

function mytime() {
    setTimeout(
        function() {
            sdk.reload('C_NT');
        }, 30000);
}
onclick = mytime();

Here this connection will load after 30 sec once the function is called.

Print this item

  Script to enable/disable visibility of a column in chart
Posted by: shreekantgosavi - 12-21-2022, 03:28 PM - Forum: BDB Designer Q & A - No Replies

sdk.applyFieldUpdates('timeline13',[{name:'column_name', properties:{visible: "true"}}] );

Print this item

  Script to enable/disable visibility of a column in chart
Posted by: shreekantgosavi - 12-21-2022, 03:23 PM - Forum: BDB - Designer - No Replies

sdk.applyFieldUpdates('timeline13',[{name:'column_name', properties:{visible: "true"}}] );

Print this item

  Altering aggregation
Posted by: neeraja.pattathil@bdb.ai - 12-21-2022, 01:44 PM - Forum: BDB Business Story Q & A - No Replies

How to change aggregation option for measure filed in story


Click on 3 dots on the right side of the measure and select the desired aggregation from drop-down

Print this item

  Global Font
Posted by: neeraja.pattathil@bdb.ai - 12-21-2022, 01:38 PM - Forum: BDB Designer Q & A - No Replies

How to use a new global font that is not present in the dashboard property?


can use it using a script in the dashboard

sdk.applyGlobalFont({'url': 'https://fonts.googleapis.com/css?family=Nunito+Sans&display=swap', 'fontFamily': 'Nunito Sans', 'useGlobalFont': 'true'});

Print this item

  How to test Components in Data pipeline?
Posted by: mohd.gulam - 12-21-2022, 07:46 AM - Forum: BDB Data Pipeline Q & A - No Replies

* Basically we can test only Transformation components of our pipeline to Ensure that the component is working properly or not.

As we know that on the top of the pipeline page there is one option called Testing pipeline,,,

1)we need to click the option Testing pipeline -it shows the components at left side of the page which is present in our pipeline

example :we have sql or python component in pipeline, it shows two components at left side of a page

2)we need to select which component we want to test first then we can select Create test case.it gives multiple options like:-

a)Test case name
b)test case description(optional)
c)input data file -(input data file of Max 10 records has to be uploaded in which we are sending data as input in a JSON file)
d)Expected data output file-(Meaning-Expected output data file of max 10 records has to be uploaded in json format)
e)schema file-(schema file has to be uploaded in this option,(meaning-Expected output data's schema has to be uploaded)
f)input data type-JSON
g)comparision logic-(meaning-while testing the component what and all has to be compared & tested ,like-comparing no. of columns,rows,data)
 
3)save the test case after configuring the above steps

4)Run the test case to know the results, we can check the status reports once it completes the test...

Print this item