Hello - Wondering if anyone has come up with a efficient way of
providing visibility for end users into the calculation logic and/or
equations that are being used by dimension members. For example: End
user pulls up a Cube View The Cube View is a mix...
Hello. I am trying to create a column set showing M1-M12 for the
previous year based on Global Time. I can do this successfully using
WFYear and POVYear as shown:
T#YearPrior1(|WFYear|).BaseT#YearPrior1(|POVYear|).Base However, this
syntax generates ...
We are trying to develop logic to do the following during
transformation: If the G/L account in the load is in a certain range and
the UD2 member is valid, load to that intersection otherwise If the G/L
account in the load is in that same range but t...
Hello - I have a SQL data adapter that connects to an external database
for data loads, dashboards, etc. Is it possible in the query to join
these external tables to tables in the Application database? The server
name in the error is the OneStream da...
I added this code to a Data Adapter:UPDATEAppPropertySETTextValue =
'2022M10'WHERE Name = 'GlobalTime'After executing the query, the value
in the AppProperty table is changed, but the value in the POV pane is
not. Log off / log on is needed for the c...
Hi, Oscar.Are you getting an error? If so, please attach it to this
thread.Two thoughts: 1) Does the user have EXECUTE permission on the
dbo.usp_GLReport stored procedure? 2) Are you entering the command as
shown? I think the correct syntax would be ...