Femke Kooij

1. Community
2. Frontend, Designer and Consumer
3. InMemory Measure to calculate daily sales in a period

Hi how is your datamodel setup? Do you have a calendar tabel with all dates and then a fact with posting date and customer id and the sales value? Then you can create in your dwh a measure with cou...

• View comment
• Created December 01, 2021 07:22
• 0 votes

1. Community
2. Administrator
3. Export of a list of data-sources and their uses in cubes?

If you have stored your dashboards/reports by source, you can get it from the basic log files. I don't have Insights installed but we do have the Auxillary Database enbaled, so some basic logging i...

• View comment
• Created November 29, 2021 13:41
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. InMemory Measure to calculate daily sales in a period

Why not create a measure that returns the datediff of 2 dates if you use calendar dates? This won't work if you're using working days, but with calendar days it should.    

• View comment
• Created November 26, 2021 07:25
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Schedued Job and presetting different criteria

Thanks Ole, I'll try A2 as that seems to be a solution for me.

• View comment
• Created November 22, 2021 07:10
• 0 votes

1. Documentation
2. ...
3. OPENID
4. OpenID user authentication

Thanks Ole

• View comment
• Created November 22, 2021 07:08
• 0 votes

1. Documentation
2. ...
3. Configuration
4. Logging Analysis Requests to Auxiliary Database

Hi, What is the logging frequency to the database? Will stats be written to database as they occur in time or will they be collected in temp log file and written to datebase every hour or so? We wi...

• View comment
• Edited September 08, 2021 08:14
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Dynamic Date based on Working days

1 addition, i had to add 1 extra month in the user dimension, in case of month change. (so previous month to date till today)

• View comment
• Created June 08, 2021 07:54
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Dynamic Date based on Working days

Hi Kristoffer, I have it working. I did adapt the logic a bit. I have an user dimension but with only 1 option of Month to Date with a criteria on Workday=1 Next I set the visibility agent to: valu...

• View comment
• Created June 08, 2021 07:19
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Dynamic Date based on Working days

thanks, I'll try this and let you know If I can get it to work (note I need it for 4 KPI components and 2 pivot tables and 1 bar chart)

• View comment
• Created June 01, 2021 09:06
• 0 votes

1. Community
2. Frontend, Designer and Consumer
3. Dynamic Date based on Working days

I need something like a user dimension with values: Today(= selected date in dynamic date criteria) Day Before = Max(Date) where WorkingDay=1 and Date<Today   I know there ahs been a post from a us...

• View comment
• Edited June 01, 2021 07:59
• 0 votes