Processing Blank Columns | Direct Import/Load v Standard Import
Rolling Quarterly Forecasts - to Import 12-month flat files - Several times daily during a cycle - 12-month Matrix Data Source 1. Forecast Q1 '25 flat file - Columns Q1-Q4 '25 = amounts 2. Forecast Q2 '25 flat file a. Columns Q1 '25 = blanks b. Columns Q2-Q4 '25 = amounts c. Q1 '25 to be refilled with actuals - using a DM Job after the initial Import 3. Forecast Q2 '25 flat file - Columns Q1 '25 = blanks a. Direct Import/Load - Wiped out refilled actuals in Q1 '25 = blanks b. Standard Import (Import, Validate, Load) - Kept refilled actuals in Q1 '25 4. Blank Columns - Q1 '25, etc = Prior Periods a. Why do Direct and Standard process blank columns differently? b. How to make Direct process blank columns like Standard? - Keep actuals in Q1 '25/prior periods in OS Data Cubes TY.
Data import from Stage to Cube
Hi, We successfully imported data from stage to cube. But while creating cube views, I am getting fewer records. Not all data is showing up in cube view. I checked the tables in the database; they have all the lines, but the cube view is importing only the first line. What can I do to get all the lines calculated in Cubeview? This account has 1343 records but cubeView fetches only 1st line.
Derivative Rule
Hello, I'm trying a Derivative Rule where I've one source target account which needs to be mapped to an another account and combination of attributes, the idea is it should create new row for each account attribute, but as I'm using multiple attribute values at once it throwing me an error Please let me know what I'm missing out or what I'm doing wrong from the below expression. A#[56000]=[ABC]:A1#[ACC-*;FTM-*;BTSRR-*;BPR-*;BSC*;CON-*]
Consolidation- Calcstatus showing CN for all period.
Hi Everyone, We recently migrated from 7.1.3 to 8.4 . after migrations, we are facing issue in Calcstatus- Consolidation from Bottom to Top ( Parent). we tried to consolidated-calcstatus from beginning of the data to till now. But its not running properly or not showing value in parent level. after closing cubeview again its showing CN. is there anyone faced this issue and find the solutions?
Error when accessing the Workflow Import step
Hi Everyone, I was recently working within a Demo Environment where I suddenly started getting error message when trying to access the import step in the Load and Transform (Import) step in the Import Workflow. The Error above pops up every time anyone tries to access the Load and Transform (Import) step. Have anyone seen this issue before and knows how to fix it? NOTE: This issue is the same across all applications in this environment. Thanks, Hamza
Source Data Condition check before Import
Is there a way I can check my source records before importing data into a stage? If I am in a workflow for Import, Validate and Load, Even before the data is imported, I would like to check my source record for a condition like if it is less than a particular value. Only if the condition satisfies, I need to proceed to import else stop the workflow. If someone has done it, can you share the setup and code for the same. Appreciate your help!
