Hi everyone. We export some of our data to a data ...
# general
l
Hi everyone. We export some of our data to a data lake using saved searches, But now we're facing a little issue to do it for the Budget: • The budget saved search hasn't a Month field available, this way, at the saved search results, we can see only the total amount by year; • I tried to use the report builder, but for this type of report (Budget x Actual), we haven't the "Available to WebQuery" option available. Do you guys know any different way to do it (export budget information with the amount by month data)?
n
You can try exploring the suiteanalytics dataset (if you have the suiteanalytics workbook feature enabled). This is able to pull the amounts by period and then you can export as csv. But if you would like to connect to a data lake you might need suiteanalytics connect for that.
šŸ‘ 1
l
Great tip, thank you Nico. šŸ˜„