Cube | Data Access | Data Cell Access Security/Slice Security by U1#Geography
Data Management Access Security Please share your expertise to set up a Cube's Data Cell Access Security / Slice Security to limit data read access as outlined below: Dimension: U1# - Geography Total_Geography = Child 1 + Child 2 = Total / Top North_America = Child 1 / NA International = Child 2 / Int'l Slice Security: Access Level - Read Data by Geography - in a CV and a QV Total_Geo_Data = Read Total data | Read NA data and Read Intl data NA_Data = Read NA data | no data access = International and Total Intl_Data = Read Int'l data | no data access = North America and Total TY for your practical advice - SMEs.
Entity - In Use Feature
Hi all, We have a situation where an Entity was created and incorrectly set up and contains data for period 2024M12 and 2025M3. We decided to create a new Entity and updated the transformation rules to ensure that the data loaded goes to the newly created member and not the old one. We have set the consolidation and ownership percentage of the old entity to 0 as added measure. We are now faced with the challenge of not deleting the member as it contains data. Kindly asking if it is advisable to set the In Use feature in this scenario and is there any impact that would cause. Thanks in advance.
Monthly vs Yearly Cube View Data
Hello everyone! I require some assistance regarding the following objectives that I have in mind for this cube view. Showing the monthly data input cells (which I have done), along with the total sum of all the months in the year. Getting a percentage by using the monthly data / current year. Currently, the Amount 227.00 under actuals - 2025 column is a member filter under rows/columns whereby i use getDataCell(CVC(Col, 1) + CVC(Col, 2) .... CVC(Col, 12)) which I know it isn't the best idea. But I want the column under 'Total' to show this amount and with this amount, I will calculate the percentage in the next table. For example, on the 2nd table (green cells), on row ACTYPE001, when the user click calculate, the answer should be 1/227 x 100 = 0.44% at Jan 2025, 2/227 x 100 = 0.88% at Feb 2025. Please advice on how I should approach these issues or any improvement or suggestion I should be doing.
Add culture to user security
I need to be able to visualize a cube view in english and in spanish. The description of the account member is set in spanish, and if I put something in the 'English' line, because the user security only has the English option in culture, the cube view would come out in english. So i need to be able to add another option for culture in the user security. ¿How can I accomplish this? Thanks!
Account is invalid due to Aggregation property
I have informational account created to store some Include/Exclude value by Entity. Now, I dont want this account to be translated and consolidated so, I have tagged AccountType to "Non Financial" while Aggregation to False. However when I turn on false its become invalid while True makes it Valid for input. Any idea what causing the issue? Based on the OS doc any informational account can be set to False.
Can we write a dynamic calc in Scenario member
Hi, I was wondering if we can write a dynamic calc in the scenario dimension? I see the field for writing the formula but somehow it is not returning anything. How can I enable the type to dynamic calc so that it works as how we use it in account or UDs?
