Forum Discussion
Cannot load datamart
Hi. I am facin the same issue. Should I create a complete new datamart?
I spent weeks to create...
Hi war4ct,
unfortunately creating new Datamart is currently the only option as far as I am aware. To retrieve Queries I have found an approach using either Postman, other API tool or Edit and resend option in Inspect (Developer tool in browser).
Start with navigating to list of Reports, Datasets and Datamarts.
- Rightclick > Inspect (Developer tool) > Network > select 'Diable cache' and 'Preserve logs' > Clear
- Click on warning icon '!' next to Datamart name and wait for Datamart unavailable error
- Collect Bearer token for auth. For getting the auth token, under the 'Headers' tab, scroll down 'Request Headers' section. Copy the value of 'authorization' field (right click -> 'Copy value'), should not be necessary as we are gonna resend same request and auth should be there
- Locate the /v1.0/myorg/groups/<[groupId]>/datamarts/<[datamartId]>?$select=etl,xmla,views API call (use Workspace and Datamart ID accordingly or filter by =etl,xmla,views)
- Right click on the failed API call > Edit and Resend
- Edit the value so it is just 'etl' <-- etl is the dataflow definition which can be used to recreate the datamart - if no Key $select is present you can either add it together with value etl or just remove ,xmla,views from URL directly
- hit Send
- if the response will be success you should be able to search the response and find all the queries from your Datamart