terrance smith's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Anthology Inc

Country

Latest Posts

Re: Automatic Filter by Calling User
@Ian Macdonald Hello Ian, what we have is a Fact table of the grain Student and Advisor that holds a record of each student and their advisor relationship.…
- terrance_smith.1
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Automatic Filter by Calling User
As a note, I am attempting to use the Model tool to set the filter, but I cannot find a way to have the filter become a parameter instead of something manually written in.
- terrance_smith.1
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Automatic Filter by Calling User

Hello, I have a client who needs to limit and automate the filtering of data based on the calling user. In this example, each advisor will be looking at their student success information.…
- terrance_smith.1
- 8 mths ago
- 3replies
- 26
- 1
- Questions & Answers
- Answered
- Answered
Re: Automated Export/Extract to SQL Server
@NPANS Clarification on option 1. I can get this setup, but I can't seem to set the filter options on the discover from the modeling tool. Is that an option or does the discovery have to be…
- terrance_smith.1
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Automated Export/Extract to SQL Server
I am trying option 1 right now and need to wait on client SQL information to confirm. But this sounds exactly like what I was looking for. Preemptive thanks and I will update this again once I get it…
- terrance_smith.1
- 8 mths ago
- Questions & Answers
- Reported - view
Automated Export/Extract to SQL Server

This is a unique client request that I am trying to assist with. The need is to export directly from a Pyramid Discovery to a SQL database. My thought was to connect SQL SSIS job and induct a CSV…
- terrance_smith.1
- 8 mths ago
- 5replies
- 48
- 1
- Questions & Answers
- Answered
- Answered

Back to top

Home

Questions & Answers

View all topics