Showing items with no data on rows

Answered
Fidan Abdiu asked on August 1, 2019

We have successfully integrated flexmonster in our ASP.NET Core application (utilizing jQuery), and we have also started using it to extract data from Microsoft SQL Server Analysis Services, using the appropriate API https://www.flexmonster.com/doc/connecting-to-microsoft-analysis-services/
We would like to know if it is possible to "show items with no data on rows". For more information on this issue, please, find attached the following files:

  1. flexmonster.png: the structure of the report that we want to generate (codes 05, 13, and 24 have no data in the fact table - we would like to display them in the table using the zero values).
  2. excel_1.png: same report generated by microsoft excel using its option "show items with no data on rows".
  3. excel_2.png: microsoft excel option "show items with no data on rows".
  4. mdx_1.txt: microsoft excel generated mdx without using the option mentioned above.
  5. mdx_2.txt: microsoft excel generated mdx when using the option mentioned above.

We would like to know if this option is also available in flexmonster.
Thank you.

1 answer

Public
Vera Didenko Vera Didenko Flexmonster August 1, 2019

Hello,
 
Thank you for explaining your case in such detail.
 
Presently, Flexmonster doesn't provide an option to show items with no data on rows.
Having such feature sounds reasonable, however, at the moment it is not in our roadmap.
We will notify you in case of any updates on the matter.
 
You are welcome to contact us in case any questions arise.
 
 
Best Regards,
Vera

Please login or Register to Submit Answer