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.
Data Cell Access Security (Slice Security) has stopped working after we upgraded to OS v8.5
Hi, After we recently upgraded to V8.5 , it seems the slice security has stopped working. Can anyone suggest what would have gone wrong? Cube Data Access Security for Entity is True The parameters are set as User is in group and Data cell in the Filter -> Apply access and stop (Read Only) User is in group and Data cell is not in the Filter -> Apply access and continue (No access) User is NOT in group and Data cell is not in the Filter -> Apply access and continue (No access) In the Account filter , am passing 1 account say Sales but when am checking the access , user is able to access all the accounts. There is no other security available in this particular base cube other than this
How to get two decimal places in Member formula
Hi Everyone, I'm trying to write member formula (not dynamic calc), below is the syntax Dim Var1 as Decimal = Math.Round(api.Data.GetDataCell("A#630000").CellAmount, 2) api.Data.Calculate("A#520000 = A#430000 "*" & Var1 & "). after that getting error "Double is not valid, input string was incorrect format".
Spreadsheet tool in v8.5 - does it work?
Trying to confirm if the spreadsheet tool in v8.5 is working for anyone in the following manner... Created dashboard with the spreadsheet tool. The page renders fine... However, when doing something as simple as Save As, the following message is generated. Excel file is defined in the configuration. One client mentioned this, so I tested this on another client with the same results. Heard this is fixed in v9.0. Is this correct or am I missing something? Thanks for any input! Ed Puente
