Cube data using SAAS, localhost/api/dataengine/cube returns empty page

Cube data using SAAS, localhost/api/dataengine/cube returns empty page

Posted by: elisabethruizm on 16 March 2018, 8:11 am EST

• 

  elisabethruizm

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 March 2018, 8:11 am EST

  I have this code in Startup class

  app.UseDataEngineProviders()
                  .AddCube("cube", @"Data source=localhost;Provider=MSOLAP.5;Initial catalog=OLAPsig", "Tenebrosa Mart Final");
  

  but when I run the application and write in the url: localhost:1234/api/dataengine/cube to see the result, the page is empty!
  
  I need your help. I have to connect my web aplplication with a cube data

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 18 March 2018, 6:31 pm EST

  Hi,
  
  It seems you are talking about SSAS not about SAAS.

  If yes, please refer to the following blogs:
  
  https://www.grapecity.com/en/blogs/using-asp-net-core-mvc-web-api-render-ssas-cubes-part-1/
  
  https://www.grapecity.com/en/blogs/using-asp-net-core-mvc-web-api-render-ssas-cubes-part-2/

  ~Manish

• 

  wesam.alziadat

  • Post Options:
  • Link
    Copy

  Posted 6 September 2018, 12:39 am EST

  i have the same issue fields file is returned empty (json with an empty array), its most probably authentication or a network issue(proxy 407) try calling the http request localhost:{your port}/api/dataengine/cube/fields it will show you a detailed error , and also did an sql profiling to check what was the user that is accessing the ssas cube , make sure that this user is authenticated and with credentials in the roles table

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 6 September 2018, 3:57 pm EST

  Hi Wesam,
  
  Please make sure that you are able to access SSAS cube. Further, from version 4.0.20182.160, the OLAP supports direct SSAS cube binding. Please refer to the following blog:
  
  https://www.grapecity.com/en/blogs/connect-microsoft-ssas-cubes-with-mvc-olap

  Hope it helps to resolve issues.

  Please let us know if you have any further queries.

  ~Manish