Extracting Metadata
Hi, I want to extract metadata in OneStream. While extracting the Accounts metadata, I want to extract both the 'Parent description' and 'Account type'. Through the grid view if you check the 'Display Parent Child Relationships' box, the account type goes away! I want to extract both of them together in a .csv file. This process also needs to be automated to be extracted on a scheduled basis. What would be the best solution to this problem?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.
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.
