Transformation.... Can I message user if....
As you can see I'm not even sure how to title this post. I have a user from a sub who has asked whether there's a way to create a popup message to the individual trying to import data if they are loading to an incorrect (but viable) intersection? I've been asked similar questions in the past about creating popup messages. I assume there must be a business rule we could create but not sure if such a thing would be possible during an event like importing data. Thoughts anyone?
Zeroing-out a local Euro Entity, still has USD amounts in RE that need to also zero-out.
Wondering how we can zero-out the translated FX noise in a local (Euro) base entity that has the accumulated FX noise showing up in USD after the entity has all of its local currency balances zeroed out. We have some adjustment USD sibling entities to this Euro entity in question but entering an offset in that entity does not remove the translated USD amount. If we set the properties to Is Consolidated = False, would this completely remove that entity from consolidated history (if we were ever to go back and reconsolidate the system)? Has anybody encountered this and what did they do? Thanks. Mike B
ColumnMapping doesn't match source or destination
Getting this error while loading data from BI Blend table to the stage data in the workflow. We have five workflow and trying to union to load the data to the stage & eventually to the cube. However when we load from one table it fail & give column mapping error but clear data and reload next one then it goes through.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.
Function to return the period associated with a date, when the period is 4-4-5 or 5-4-4
Has anyone written a complex expression that takes a date as an input, and determines the period associated with the date, when periods are not based on calendar ends (for example, 4-4-5, or 5-4-4)? There doesn't appear to be a BRApi function for this, but perhaps I'm missing something. Absent a function, what techniques are recommended? Thanks!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?How to setup transformation rule to map if an item is a child member of a (another) dimension parent
I am looking to create a transformation rule for Accounts to map to a destination if the Department on the record is a child of a specific parent in the OS department dimension. ACCT600 DEPT101 --> ACT_EXP600_100 ACTT600 DEPT321 --> ACT_EXP600_100 Where departments 101 and 321 are descendants of Dept_TotRD
