Skip to main content
B
brprkr
April 15, 2024
Solved

Did a budget import to OS, now having trouble pulling it into an excel using XFGetCell

  • April 15, 2024
  • 1 reply
  • 0 views

Relatively new to OS and trying to figure out what may be preventing me from pulling newly imported budget data into an excel report via XFGetCell.

I've verified the data exists in OS using the dashboards.  Now I'm trying to compare the data from the Actual Scenario with the Budget data in Excel.  I'm able to pull the actual data without issue.  The Budget data, however is coming through as $0.  To troubleshoot I change just the scenario parameter in the formula from Budget to Actual and the Actual data pulls as expected.  So, I believe there must be a step I'm missing in the import to push it to wherever it gets grabbed by the GetCell formula.

Hoping someone out there has an idea.

TIA

Best answer by Krishna

brprkr  -

1. Did you configured extensibility in your environment ? Make sure you are pulling the data from the right cube. 

2. Check the POV and try to compare it with the XFGet & Cube View. Try couple of intersection from the base pov.

3. Verify the data from data import for one period and pull the same intersection with XFGet.

 

 

1 reply

K
KrishnaAnswer
April 15, 2024

brprkr  -

1. Did you configured extensibility in your environment ? Make sure you are pulling the data from the right cube. 

2. Check the POV and try to compare it with the XFGet & Cube View. Try couple of intersection from the base pov.

3. Verify the data from data import for one period and pull the same intersection with XFGet.

 

 

B
brprkrAuthor
April 16, 2024

Krishna 

Thank you.  I had overlooked the data source parameter.  Actuals come from a different source than the manual budget import.

Terms & ConditionsAccessibility statement