Hi Gianni/Christian, Thank you for the response. We need to connect Kafka from OBIEE or DV either from RPD or by using direct database request to access the kafka real time data. As you mentioned in the above post, can you please let me the approach for creating JDBC driver to connect kafka. We are trying with the below…

Graph should looks like as above in the prompt we will select top range and rest of the items should show like this. Using presentation variable we till selecting top N range we did, and for showing rest of the items can anyone suggest on this how to achieve. Thanks in Advance,

Thank you all for the response. We are able to find LEAST and GREATEST dates using evaluate function as below EVALUATE('LEAST(%1,%2)', "Task"."Date1","TasK"."Date2") EVALUATE('GREATEST(%1,%2)', "Task"."Date1","TasK"."Date2") But not able to extract year from evaluate LEAST function and compare with 2018 any help on this…

Hi Christian, Thank you for the response. Yes date prompt is converted string format field from datetime field. Thanks,

Thanks for the reply. We used below year and month functions but format we are getting is 20186, we are looking for 201806 can you suggest on this. CAST(YEAR("table.Date") AS CHAR)||CAST(MONTH("table.Date") AS CHAR) is there any other function which we can achieve in 201806 format

Hi Gianni, Thanks it worked. Regards,

Hi Gianni, Thanks for your reply. In RPD we don’t have any columns to sort the MMYYYY field, so we can create new column by using case statement and set the numbers for the month year and use that column as sort order column. Regards,

Hi Gianni, Thank you for the Responce. Regards,

@Christian, Yes, before posting the question I have done google but in most of the blogs they told about the setting content level in our case we didn’t create any hierarchy’s for the dimensions. So I have posted here for taking help and provided all the details. Thanks,

can some one help\suggest on this. Thanks in Advance,

I want to do changes in RPD level, using below logic in the date field in BMM layer is enough or I have to change the data type for physical column as well, bcoz date field is varchar data type. TO_DateTime(SUBSTRING("Sales"."Date" FROM 1 FOR 8),'dd/mm/yyyy')

Hi Gianni, Thanks for the reply. I have tested above logic in report level for the date column its working, but I tried with changing diff format like DD/MM/YYYY, YYYY/MM/DD, MM/DD/YYYY. But It was showing data in only 1 format (ex:05/28/2014), I’m looking for the format DD/MM/YYYY(28/5/2014). can you suggest on this.…

Thanks Gianni for the reply. I will be trying this approach, making another fact_date table adding all date related column from physical tables (detail dim table) and creating required measures using Timediff and aggregation sum. Joining new fact_date table with summary dim table, already there was a snowflake join with…

Can anyone suggest on this or how we can create measures from dim tables (In my case we have start date and end date column need to find Time diff of hours and days between the date columns). Thanks,

Hi Christina , Thanks for your reply. date fields was available only in dim columns calculating for timediff . Is there any other approach to achieve this I have added another point in the question Need to add another point. Dimension tables is a detail level table it had snow flake join with another summary dim table and…

Hi Berg, Thanks for your reply. All 10 tables are fact tables joined with diff dim tables, we need to bring common fields of all fact tables into 1 table. Suppose column ABC exist in 7 fact tables then it as to make union of all those 7 fact tables and show the results. Hope I made some sense. Thanks,

Thanks Joel its working.