Latest Activity

code

Facing Problem with interpolation variable use

Hi Team, -Source is Oracle, using this JDBC source Requirement: I want to paraterized the base view with a date column in it, when anyone tries to run that bv it should ask them date before it runs Date column name is start_date and its in timesta...

Interpolation Variables

code

Passing operator as interpolation variable

Hello, I would like to pass "Operators" (=,<,>etc.) as interpolation variable in my derived view. Is it possible to achieve or do we have any other alternatives Thanks in advance

Interpolation Variables

code

JSON Data Source with optional Interpolation Variables

I want to make a JSON Data Source from this URL: https://data.cdc.gov/resource/52kb-ccu2.json This URL supports filtering by adding query strings to the end of the URL. These simple query string filters are optional. Here are 2 such examples? https://...

Interpolation Variables JSON Data Source JSON Datasource

code

change name of interpolation variable in base view

Hi, I have a base view that i created with the mandatory input parameter using this sql statement from create from query command. SQLSENTENCE=select * from edl_cs_space_plan_analysis.v_lab_building_floor_space_org_alllocation where space_control_nbr =...

Interpolation Variables

code

how to use interpolation variables in base view?

i want to use input prameter field in base view. Can someone tell proper method .

Interpolation Variables

code

Interpolation Variable - Date function

Hi, I am trying to create a base view with query from DB2 in which I included 2 parameters Begin_date, End_date that are added in where clause to filter Date(confirm_date) column. Example: Select * from Table where Date_column between @Begin_date and ...

Date Conversion Interpolation Variables DB2

code

Interpolation Variable using a formula - Julian calendar date

I have a data source which requres a dynanmic file name to be reference using a Julian date - last two digits of the year and the current day number. So 2022-04-04 would be 22094. Is there an easy way to include this value as part of the interpolatio...

Formula Interpolation Variables Date time function

code

Interpolation Variable with Power BI

I have created final view with interpolation variable. I would like to use this final view in power BI. I need to pass value to the interpolation variable from power bi report and load only the particular dataset to the model. How can I achieve this

Interpolation Variables Power BI

code

How to search for a range of dates based on a text value - Interpolation variable

I currently have a baseview that with an interpolation variable for a date value that can be used to dynamically target a specific CSV file on AWS S3 as the source. select * from hcc_dv.dv_ctigeneral_s3_gdw_backupdate where backupdate = '09-01-2021' ...

Interpolation Variables AWS S3

code

CustomWrappers and base view Interpolation variables

Hello, We are in the process of creating a custom data source for one of our internal sources. It takes two CustomWrapperInputParameters, both mandatory strings. public CustomWrapperInputParameter[] getInputParameters() { return new CustomWra...

Interpolation Variables Custom Data Sources