Hello,
I have a table with few rows that has null values and I have to show total at the end
I have used =sum(B4:F4) that didn't work, tried something like below:
=(if(B4=null,0,B4)+if(C4=null,0,C4)+if(D4=null,0,D4))/3
that did now work eithe...
Hello,
I have a requirement to calculate the date difference based on Calday.
Model created is based on Live Connection BW 7.5, BeX query.
As per the note 2788384 - Date based calculations are unsupported, wondering is there a work around?
ap...
Hello,
When trying to create a write back model the Time date range is causing an error.
In model settings > Planning and Time Range ... unable to edit the 'To' date field and thus unable to save the model.
however, when creating a basic model ...
Hello,
Is there a way to bypass the prompt screen to enter user credentials when a user tries to access the story created on a Live Connection model?
I understand Live connection purely works on BW authorizations, no security set up required apar...
Hello,
When trying to create a model using direct connection I am seeing the error - "Driver Error (#2700) Invalid meta data from the server".
I know this is a common error and disabling cookies generally helps, I have disabled cookies in browser...
Hello Cornelia,Thank you for taking time to respond on an old thread.In fact on my side I have adjusted the date format on my user profile in BW and that is how I overcame the issue.However, thank you for sharing your insight.Regards,Ellora
Thank you Debjitwhat I am looking for is Date Difference type in calculation editor to calculate days difference between the user selection date and current date.
Root Cause:- This issue occurs if there is a member with ID 9999 exists in BPC Time dimension, even with a prefix or a suffix e.g. INC_9999, EXP_9999 or 9999_ABC etc. are not allowed.Solution:If allowed remove the member id from the Time dimension co...
