About Mr-Singh

Mr-Singh

I have a date column and I want to derive Week range for that column considering Monday-Saturday as first day and last day of the week. I tried the same in transformations it did work but. It fails when loading the data. It asks for transformation to...

Mr-Singh

I have built a new model with data source as csv. Therw were 7 transformations and I arrived at a final column as output which I need. Now when I m trying to load new data. Model is expecting all the columns to be mapped from source. How to reload th...

Mr-Singh

My requirement is I have date column and gross, net> I wanted to show week range as text or dimension in display with Gross, Net to show the values for that week. How can I achieve it. My source is csv for now

Mr-Singh · 03-17-2023

I have a calculation where in I want to write the calculation ffor a comp Code, it should do A*1.122. This is working for the lowest granularity but it's not working for High levels of Granularity. Any solutions, thoughts on the logic/Code for the sa...

Mr-Singh · 03-01-2023

I am looking to show 2 measures via IF statement. is it possible. for example I have 4 Measures. if user selects a - 2 measures should display in story. If user selects b 2 other measures should display in table of a story. If possible can share the ...

Mr-Singh

Would like to exlain further, I have lets says 4 columns in source csv have derived one column using transformation lets say substring,. Now I added some more records to excel and trying to load the data. It asking for the transformed column to be ma...

Mr-Singh

Hi Venkat, I tried this in new model, it did work but when I upload new data from flat file. For all the new tranformations it is asking for source column to map Please suggest how to move ahead here, Its not allowing to load the data

Mr-Singh · 03-20-2023

Nikhil - Now I have 2 other hierarchies one with Plant-Region-Sales and another is let's say Plant-y-z for these the formula we used earlier is not working. for my normal Hierarchy with Plant-Sub Div is working. Is there anyway to make it Global and ...

Mr-Singh · 03-18-2023

Nikhil,It works as of now. I will do a detailed test and get back if I need further help. Appreciate your response. Thanks.

Mr-Singh · 03-17-2023

my requirement is calculation should be applied to all the granules, right from lowest granule til top level. but it doesn't work for Higher levels. Only lowest granule it is working now. And i am looking out for if any right syntax to achieve it so ...

User Statistics

User Activity

I have a date column and I want to derive Week range

Transformation issue in SAC Data Model

I have data like Date, Net, Gross. I want to derive values by Week Range text as dimension

Hierarchy Value doesn't work, model in SAC to Highest level of Granularity

Display two measure via IF Statement or any other option in SAC Story

Re: Transformation issue in SAC Data Model

Re: Derive Week Range based on Date (SAC Model)

Re: Hierarchy Value doesn't work, model in SAC to Highest level of Granularity

Re: Hierarchy Value doesn't work, model in SAC to Highest level of Granularity

Re: Hierarchy Value doesn't work, model in SAC to Highest level of Granularity