Dear SCN,I know that there are many discussions on the same topic. Though I have some questions about that. I have read the document . There I see a comment :"Most new SCN members and members who have not yet contributed content are placed into a mo...
In some discussions, I realized that there is a need to define condition according to the value of a characteristic. It is very easy to deal with key figure values to create a condition, but when it comes to the characteristics, we need some wor...
Dear Team,Lately I have realized that a few of my posts are rejected or removed by SCN moderators. I really take care of rules of engagement and could not realize what the problem may be. The notifications did not include a reason. So please can you ...
For some reports that process a huge amount of data, the users may go mad about the runtimes of queries. For some extend we can improve the performance by playing with the design of the datasource, dataflow, the queries or the aggregates. In this do...
Hi,Is there any recent problem updating the points? I just realized that my points went up by 3 although one has rated my blog post as five stars (In reputation I see like that). I just faced the same yesterday when someone marked my answer as correc...
Hi Raja,If you have ContractbeginDate as a characteristic referenced by Calday, then you can directly use the 0VDAYLM variable to restrict for previous month. If your characteristic is not a reference of 0calday, you can write your own code to restri...
Hi Sesha,If the number of plants is few, you can create a structure in columns create RKFs for each key figure restricting one plant. And for the blocked quantity, you don't restrict any plant. Bu this type of approach needs maintenance when new plan...
Hi Raja,If you don't have any key figures in your cube and not planning to have any on the report, then create a CKF with a formula as 1 and use this KF with the restrictions I mentioned in my previous post. I think that's something like Swati has su...
Hi Raja,Follow this procedure.Create a selection (lets say KF1) including your KF, with a filter on Start Date where you filter with the reuqired date range.Create another selection (lets say KF2) including your KF with a filter on End Date where yo...