Forum Discussion

Steels_Cat's avatar
Steels_Cat
Helper I
3 years ago
Solved

Dynamic parametars for SAP BW

What is currect way to replace below values with dynamic parametars. I would like to get data from SAP BW for last 12 months and I need to create dynamic parametar to replace these values. For exampl...
Need Help
  • Steels_Cat's avatar
    Steels_Cat
    3 years ago

    This is what I have built. Now it seems to work correctly .

    date_from = DateTime.Date(Date.AddMonths(DateTime.LocalNow(), -12)),
        date_to = DateTime.Date(DateTime.LocalNow()),
        date_from_formatted = Date.ToText(date_from, "yyyy-MM-dd"),
        date_to_formatted = Date.ToText(date_to, "yyyy-MM-dd"),
        #"Added Items" = Cube.Transform(YourTable),
            {
                {Cube.ApplyParameter, "DATEFROM", {date_from_formatted}},
                {Cube.ApplyParameter, "DATETO", {date_to_formatted}},

Steels_Cat's avatar
Steels_Cat
Helper I
3 years ago

This is what I have built. Now it seems to work correctly .

date_from = DateTime.Date(Date.AddMonths(DateTime.LocalNow(), -12)),
    date_to = DateTime.Date(DateTime.LocalNow()),
    date_from_formatted = Date.ToText(date_from, "yyyy-MM-dd"),
    date_to_formatted = Date.ToText(date_to, "yyyy-MM-dd"),
    #"Added Items" = Cube.Transform(YourTable),
        {
            {Cube.ApplyParameter, "DATEFROM", {date_from_formatted}},
            {Cube.ApplyParameter, "DATETO", {date_to_formatted}},