I have created a dataclass dimension, which should be calculated based on time. It should be yoga for every last 7 days, parallel period etc. I've created a named set for the last 7 days:
Make SetCreditCanqu [Last 7 days] AS {Stormm (Sist ("[TMTAMMADTS]. [Date Calci]. & Amp; [" + Cestrate (format (now (), "YA-MM-DD") + "T-00: 00 : 00) "): StormMail (Cestrate (" [DMN]]. [Datecoded]. & Amp; ["+ Cestrate (format (now (-7)," YY-MM-DD ")" + T00: 00: 00] "))}; And then tried to use it on a member's member: Make a Member CurrentCube [Dmn_ DateTool]. [Date Tool]. [Last 7 days_] Like
Tomorrow ({StrToMember (Cstr ("[Dmn_Dates]. [Date calc]. & Amp; [" + Cstr (format (now (), "yyyy-MM-dd") "+ T00: 00: 00]")) : StrToMember (Cstr ("[Dmn_Dates]. [Date Calc]. & Amp; [" + Cstr (format (now () - 7, "yyyy-MM-dd" + "T00: 00: 00]")) }, [[Dmn_ DateTool]. [Date tool]. [Regular], measures. Lead counter), visible = 1; This does not work, what I get is a calculation The magazine is [the last 7 days] that show the same value as the regular value.
Thanks also for reading
Let's check the validity of the generated set Singing and will correct member; Like Sth: Choose
[last 7 days] at 0 ... Maybe You have to specify with: Now () - 7 : Now instead of now (): now () - 7 ...
Comments
Post a Comment