About azm_azm

azm_azm

Hi,Here is the scenario. I want to write a data action logic which calculates the average sales based on no of products present in the transactional data. For example, product quantity is present for three products in the transactional data. To calcu...

azm_azm

Hi, Here is the scenario,There are four dimension as Factory, Location, Type, Account in the model. FactoryLocationTypeAccountValueASeattle#Sales Qty150ASeattleXPrice10BCalifornia#Sales Qty95BCaliforniaYPrice7I want to write a data action logic which...

azm_azm

Hi,There is a scenario where the values needs to be allocated from brand to SKU level. Example, I have sales of USD 1200 and it needs to be allocated down to SKU level based on actual SKU details. I'm able to write the allocation logic for this scena...

azm_azm

Hi,I'm facing the issue with Null values while writing the logic in data actions. Here is the scenario. I have two Models. Model A, has units and sales as account. Model B, has additional sales and commission % as account. The data is written in Mode...

azm_azm

Hi,I want a syntax/memberset definition for date dimension in data action where no matter whatever the start date or end date of version is configured, data action should always be executed forJan of CY.For ex, Actual : Start Date is 202401 End Date ...

azm_azm

Hi ashok.rajashekar , I'm using New Model type and it is built on acquired connection.

azm_azm

nikhil_1486 ,." I havent tested that if you normally remove a dimension from layout then values are posted to # member" . -- I think there is a misunderstanding here. I agree with you this doesn't happen.My question is if I do not have a specific d...

azm_azm

nikhil_1486 I can add a filter for "#" but this should be the standard behavior , right? Values going to "#" by default without adding any filters

azm_azm

Thank you so much nikhil_1486 .

azm_azm

In the above code, I'm actually writing back the data at model but I don't want this to happen. - Using attribute to aggregate is a good approach. I am not sure what is the issue in this approach - If I pull a report by product then numbers would be ...

User Statistics

User Activity

How to find average based on entries of transactional data?

How to derive the master data values from existing transactional data using data action?

How to allocate values after null entries check using data action

Null values handling using LINK function in data actions in SAP SAC

How to execute data action from Jan of Current year always?

Re: Year over year calculation not working as expected

Re: Values not disaggregating to "#" member during data entry?

Re: Values not disaggregating to "#" member during data entry?

Re: Data Action to Aggregate the members and then perform calculation on the aggregated members

Re: Data Action to Aggregate the members and then perform calculation on the aggregated members