Helo , this is super help full. I tried this with for a date and when the parameter date type , I'm not getting any value. When I take parameter as text it is fine. How to fix it?
Hi, thank you for the info. If we have large query and it is having multiple sub queries and in each sub query if we are passing couple of parameters and some sub queries are using same parameters that time how to handle this? And number of parameters are limited to max 10.
How would you do it in Snowflake SQL? I tried using : eg.RETAILER_NAME = ? AND eg.PROGRAM_GROUP_NAME IN (SELECT VALUE FROM split(?,',')) first one is single parameter and 2nd one is multi-parameter.
@@HariBI yes i already did use ? symbol but it returns an error in paginated report just like this The Value expression for the query parameter '?' contains an error: Index was outside the bounds of the array. any idea? :)
@Hari Can you make video on passing multiple parameters through oracle sql query which is not working... But when we pass dates its working so it's little bit confusing and with others it's not working.. Please make the video..
Hi Hari, Thanks for Video, am trying to use the Amazon Redshift as the data source , any idea how to split the comma seperated string into rows and use that values in Query..pls help me on this
You need to use Split_Part but may not be straight forward. Refer - www.holistics.io/blog/splitting-array-string-into-rows-in-amazon-redshift-or-mysql/
Hi Hari, Thanks for sharing the video. Could please help me with Amazon redshift split function. How to do it for dynamic spit by giving the values in parameter
I am not sure what is the split function available in redshift. you can try the dynamic expression. check this th-cam.com/video/N-FmK3ZeiNk/w-d-xo.html this doesn't require split function
What if we want to pass integers rather than string values? I'm running into an issue where I can only get my report to filter when I enter one ID number (BIGINT type). When I try to add another ID in the parameter field, it get a "ERROR [22018] Numeric value '9135969,93392572' is not recognized". This video was incredibly helpful, this is just one step that I'm not able to figure out.
Thanks for another video with detailed explanation!
There are more videos coming!!!
@@HariBI thank you sir!
Helo , this is super help full. I tried this with for a date and when the parameter date type , I'm not getting any value. When I take parameter as text it is fine. How to fix it?
It is in snowflake btw
Hi, thank you for the info. If we have large query and it is having multiple sub queries and in each sub query if we are passing couple of parameters and some sub queries are using same parameters that time how to handle this? And number of parameters are limited to max 10.
Hi Sir, how can we make mandatory parameter coming from HANA views dynamic in paginated reports
Hey Hari, your new subscriber 😀
How would you do it in Snowflake SQL? I tried using :
eg.RETAILER_NAME = ?
AND
eg.PROGRAM_GROUP_NAME IN (SELECT VALUE FROM split(?,','))
first one is single parameter and 2nd one is multi-parameter.
Need to check how to handle split in snowflake.
@@HariBI Hi Hari, any luck? Thanks!
@@riteshkothari1647 use this - (select t.value from table(SPLIT_TO_TABLE(?,',')) as t)
what should I use for MYSQL? Is there a similar function as String_Split()
Hi, when i m using the oracle query (from the description) 4 parameters are being formed, any idea how to deal with the same ?
Hi sir, split is not working for Denodo db can please help me for this
Would you know what function I can use for spring split using Google Big query?
you can try with dynamic expression which doesn't require split function - th-cam.com/video/N-FmK3ZeiNk/w-d-xo.html
Hello,
good day.
Do you know how I can convert the '1' IN (@PARAMETER) in snowflake? we're having issues running it on paginated report.
Are you connecting through ODBC? If yes then you need use question mark symbol. I have a video in my channel on odbc. Pls check
@@HariBI yes i already did use ? symbol but it returns an error in paginated report just like this
The Value expression for the query parameter '?' contains an error: Index was outside the bounds of the array.
any idea? :)
Then need to investigate. We can connect this weekend if you are ok. Reach me at dataonmyview@gmail.com
@@HariBI Thank you so much Hari, I'll email you and let's connect. Good content by the way! really helpful
Can you make a tutorial with power bi datasets as connector (using DAX), so paginated report is called from a power bi app
@Hari Can you make video on passing multiple parameters through oracle sql query which is not working... But when we pass dates its working so it's little bit confusing and with others it's not working.. Please make the video..
I forgot to include the syntax for oracle which I mentioned. Let me add in the description
@@HariBI In which description you will gonna add.. As I am not seeing any description? Also can we pass parameters within CTE.
Check this video description itself
@@HariBI Hello but wheres the exact syntax.. I did not got it..
Hi Hari. Great video. Do you know if it’s possible to this with DB2?
It should be possible
It isn’t working for DB2. Can you please help with the syntax?
Can we use where clause in Iif statement?
Hi Hari, Thanks for Video, am trying to use the Amazon Redshift as the data source , any idea how to split the comma seperated string into rows and use that values in Query..pls help me on this
You need to use Split_Part but may not be straight forward. Refer - www.holistics.io/blog/splitting-array-string-into-rows-in-amazon-redshift-or-mysql/
PBI report builder didn't recognise string_split function, Is anyone face this?
'In' or Inlist' operator is not working at report builder report level
Thank you realy it is helpfull, Can you add Multi-value DATE parameters in ODBC connector.
Hi Hari, Thanks for sharing the video. Could please help me with Amazon redshift split function. How to do it for dynamic spit by giving the values in parameter
I am not sure what is the split function available in redshift. you can try the dynamic expression. check this th-cam.com/video/N-FmK3ZeiNk/w-d-xo.html this doesn't require split function
How to create a parameter for snowflake connection??
If you have ODBC support to snowflake then you can follow how I created with SQL Server.
@HariBI please help with data bricks i tried multiple ways
Have you tried Databricks ODBC?
Hi can you make tutorial for this with google bigquery?
very unhelpful
Thanks
What if we want to pass integers rather than string values? I'm running into an issue where I can only get my report to filter when I enter one ID number (BIGINT type). When I try to add another ID in the parameter field, it get a "ERROR [22018] Numeric value '9135969,93392572' is not recognized". This video was incredibly helpful, this is just one step that I'm not able to figure out.