Badges
Latest Posts
-
Dynamic calculation measure for Prev Qtr End using selected date of report
Hi I am wondering how to get the following functionality in a report Run the report for one Date (user select this date through a prompt when running report) The report should bring data for Date…
- Answered
-
How to modify the WHERE clause conditions of SELECT statement before sending the query to database
Hi Assume I have a fact table (FactSales) and two dimension tables (DimDate and DimProduct) setup in a star configuration with following relationships FactSales.Date = DIMDate.Date FACTSales.…
- Answered