OneStream Code Utility

Stop wasting 8+ hours per week switching between tools. Debug, query, and deploy OneStream applications without leaving VS Code.

500+ OneStream developers trust this extension. Join them today.

🎥 Watch How It Works

See OneStream Code Utility in action! Watch our video tutorial series:

Learn everything from installation to advanced features with step-by-step video guides. Perfect for visual learners!

💰 The Real Cost of Context Switching

If you're a OneStream developer making $75/hour, every week you lose:

2 hours switching between Business Rule Editor, error logs, SQL tools
3 hours waiting for exports, imports, and deployments
2 hours debugging production issues across multiple interfaces
1 hour managing file versions and Git conflicts

That's $600/week in lost productivity = $31,200/year.

OneStream Code Utility recovers that time for $4.95/month.

🎯 Real Developer, Real Results

"I used to spend 30 minutes every morning checking production error logs, then another hour when issues came up. Now I see errors in real-time in VS Code. Saved me 6 hours last week alone." — Senior OneStream Developer at Fortune 500 Financial Services Firm

"The SQL Query Editor with schema explorer is a game-changer. I can test data transformations instantly without opening SQL Management Studio." — OneStream Consultant, Big 4 Accounting Firm

⚡ See the Difference

❌ Before OneStream Code Utility

Scenario: User reports a calculation error in a Finance Rule

Open OneStream web interface (load time: 30s)
Navigate to error logs (4 clicks, 20s)
Find relevant error (scroll, search: 2 min)
Copy stack trace
Open SQL Management Studio (30s)
Write diagnostic query (2 min)
Find the issue
Switch to Business Rule Editor (30s)
Export rule to XML (1 min)
Open in text editor (30s)
Make changes
Import back to OneStream (1 min)
Test and verify

Total time: 12-15 minutes per issue

✅ After OneStream Code Utility (Premium)

Same scenario with OneStream Code Utility:

See real-time error notification in VS Code status bar
Click error → view full stack trace (2 seconds)
Cmd+Shift+Q → SQL Query Editor opens with schema IntelliSense
Run diagnostic query (30 seconds)
Edit rule directly in VS Code with C# IntelliSense (2 min)
Generate XML deployment package (10 seconds)
Deploy and verify

Total time: 3-4 minutes per issue

You just saved 10 minutes. Do this 10x per day = 100 minutes saved daily.

🚀 Premium Features That Pay for Themselves in 10 Minutes

1. Task Activity Viewer 🆕

Monitor OneStream task execution history in real-time
View all task details including sub-tasks with unlimited hierarchy depth
Advanced filtering by username, application, status, and time range
Search tasks by description
Click-through to error logs from failed tasks
Export task data to CSV for analysis
Resizable details panel (drag to resize 300px - 1200px)
Perfect for: Production monitoring, performance analysis, troubleshooting workflows

Time saved: 10-15 minutes per production issue investigation

2. Real-Time Error Monitoring

Errors appear in VS Code the moment they happen in OneStream
Full stack traces with one click
Filter by user, application, or time period
No more logging into web interface just to check logs

Time saved: 5-10 minutes per error investigation

3. SQL Query Editor with Schema Explorer

Full database schema IntelliSense (tables, columns, stored procedures)
Run queries against Framework, Application, or external databases
Query history with search and re-run capability
Results exported to CSV instantly
Safety checks prevent accidental data deletion
Flexible Layouts for Multi-Monitor & Small Screens:
- Open side-by-side with your code (Ctrl+Shift+Alt+Q)
- Open in a separate column below
- Choose your preferred layout (Ctrl+K Ctrl+Q)
- Drag tab to separate window for multi-monitor setups
- Responsive design automatically adapts to smaller screens
- Collapsible schema sidebar - perfect for laptops
- Compact mode for maximum space efficiency
Customizable Preferences:
- Set default opening layout (current/beside/below)
- Start with schema sidebar collapsed
- Enable compact mode for smaller displays

Time saved: 15-20 minutes per day testing queries

4. Rule Synchronization

Pull any rule from OneStream database to your local workspace
Check sync status before deploying (avoid overwriting changes)
Team collaboration without conflicts
Complete Git integration for version control

Time saved: 10-15 minutes per deployment cycle

5. C# IntelliSense for OneStream APIs ⭐ (Cross-Platform)

Full autocomplete for BRApi, SessionInfo, api, si
All OneStream types and methods
Version-specific IntelliSense (7.4, 8.0, 9.0+)
No more switching to OneStream docs
Catch errors before deployment
Works on Windows, Mac, and Linux!
- Windows: Full DLL reference support
- Mac/Linux: Full IntelliSense with or without DLLs
- Setup wizard automatically configures for your platform

Time saved: 20-30 minutes per day (fewer runtime errors, faster coding)

6. AI Assistant Integration (Beta)

Auto-generates CLAUDE.md documentation for AI pair programming
Your AI assistant understands OneStream context
Faster onboarding for new developers

Time saved: Variable, but huge for complex troubleshooting

7. OneStream Code Compilation 🆕

One-click compilation of workspace assemblies and business rules directly from VS Code
Workspace Assemblies: Compile entire assemblies with all modules
Business Rules: Compile individual Finance, Extender, Connector, Parser rules and more
Errors and warnings appear in VS Code Problems panel instantly
Click any error to jump directly to the line in your source code
Automatic diagnostic clearing when recompiling (no stale errors)
Success/failure toast notifications with error/warning counts
Automatic push before compilation ensures you're compiling the latest code
Requires OCE OneStream component v2025.11.16 or later

Time saved: 5-10 minutes per compile cycle (no OneStream client switching)

📊 Feature Comparison

Feature	Free	Premium
Import/Export Business Rules	✅	✅
XML Generation	✅	✅
Smart File Organization	✅	✅
Git Integration	✅	✅
Real-Time Error Logs	❌	✅
SQL Query Editor	❌	✅
Database Schema IntelliSense	❌	✅
Rule Sync (Pull from Database)	❌	✅
Multi-Environment Support	❌	✅
C# IntelliSense (BRApi, etc.)	❌	✅
Query History	❌	✅
AI Assistant CLAUDE.md	❌	✅
Workspace Assembly Compilation	❌	✅
Business Rule Compilation	❌	✅
Priority Support	❌	✅

💡 Who This Is For

Perfect for:

Senior OneStream Developers who debug production issues daily
Consultants managing multiple client environments
Development Teams who need version control and collaboration
Solo Developers tired of juggling 5+ tools simultaneously
Anyone who values their time at more than $4.95/month

You'll Love This If:

✅ You open SQL Management Studio multiple times per day
✅ You've ever lost work because someone overwrote your rule
✅ You debug OneStream errors more than once a week
✅ You wish BRApi had autocomplete
✅ You use Git for everything else (why not OneStream?)

🎁 Start Your 14-Day Free Trial

Full premium access. Cancel anytime during trial - no charge if you cancel.

Get Started in 2 Minutes:

Install the Extension
- VS Code Marketplace
- Or search "OneStream Code Utility" in VS Code Extensions
Start Free Trial
- Click the OneStream icon in sidebar
- Click "Start Free Trial" button
- Enter your email → Instant activation
Connect to OneStream
- Click connection status in bottom bar
- Enter OneStream URL and credentials
- Select application → You're ready
Try Premium Features
- Cmd+Shift+Q (Mac) or Ctrl+Shift+Q (Windows) → SQL Query Editor
- Click error icon in status bar → Real-time error logs
- Right-click any rule → Pull from Database

After 14 days, you'll only be charged if you haven't cancelled. Try it risk-free.

Start Your Free Trial Now →

🛠️ Installation

VS Code

Open VS Code
Press Ctrl+Shift+X (Windows/Linux) or Cmd+Shift+X (Mac)
Search "OneStream Code Utility"
Click Install
Click the OneStream icon in the sidebar

Cursor IDE

Open Cursor
Press Ctrl+Shift+X
Search "OneStream Code Utility"
Click Install
Works exactly like VS Code

📖 Quick Start Guide

Free Features (No Trial Needed)

Import OneStream Rules:

Click OneStream icon in sidebar
Click "Import Files" button
Select XML or ZIP file from OneStream export
Files automatically organized by rule type

Export to XML:

Select rules in OneStream explorer
Right-click → "Generate XML from Selected Files"
XML files created in ./GeneratedXML folder

Setup Git:

Command Palette → "OneStream: Setup Folder Structure"
Creates OneStream-friendly folder layout
Command Palette → "OneStream: Check .gitignore Recommendations"
Adds recommended Git ignore patterns

Premium Features (14-Day Free Trial)

View Task Activity: 🆕

Connect to OneStream environment
Click task activity icon (clock) in status bar
Filter by username, application, status, or time range
Click any task to view details and sub-tasks
Click error buttons to view related error logs
Export data to CSV for analysis

View Error Logs:

Connect to OneStream environment
Click error log icon in status bar (or Cmd+Shift+E)
Filter by user, app, time
Click any error to see full stack trace

Run SQL Queries:

Press Cmd+Shift+Q (Mac) or Ctrl+Shift+Q (Windows)
Select connection (Framework, Application, etc.)
Type query (schema IntelliSense appears automatically)
Press Run Query or Cmd+Enter
Export results to CSV if needed

Pull Rules from Database:

Right-click any rule → "Pull Rule from Database"
Or click "Pull All Unencrypted Rules" button
Compares local vs server versions
Updates local file with server version

Enable C# IntelliSense (All Platforms):

Command Palette → "OneStream: Setup C# IntelliSense"
Select OneStream version (7.4, 8.0, etc.)
Mac/Linux users: Choose if you have DLLs or skip for basic IntelliSense
Windows users: Point to OneStream DLL directory
Start typing api. or BRApi. → See autocomplete magic

Mac/Linux users: Full C# IntelliSense works without DLLs! If you have access to DLLs (network share, VM, Remote-SSH), you'll get even better BRApi autocomplete.

💼 Pricing & Plans

Free Forever

$0/month

Perfect for occasional OneStream work:

Import/export business rules
XML generation and packaging
File organization by rule type
Git integration setup
Community support (Discord)

Premium

$4.95/month (billed monthly, cancel anytime)

Everything in Free, plus:

⚡ Real-time error log monitoring
🗃️ SQL Query Editor with schema IntelliSense
🔄 Rule synchronization (pull from database)
🌍 Multi-environment support (dev, test, prod)
💻 C# IntelliSense (BRApi, SessionInfo, all OneStream APIs)
📜 Query history with search
🤖 AI Assistant integration (CLAUDE.md)
🎟️ Priority email support
🚀 Early access to new features

ROI Calculator:

If you save just 20 minutes per week = 1.4 hours/month
At $75/hour = $105/month value
Premium costs $4.95/month = 21x return on investment

Enterprise

Custom pricing for teams

Team licenses (volume discounts)
Custom integrations
Dedicated support
Training sessions
On-premise license server

View Pricing Details →

🔒 Security & Privacy

We take security seriously:

✅ All data stays on your machine - No code or rules sent to external servers
✅ Encrypted HTTPS connections - All OneStream connections use TLS
✅ Token-based authentication - No passwords stored locally
✅ No telemetry or tracking - We don't collect usage data
✅ License validation only - Only your email and license key are sent to our server

Your OneStream data never leaves your network.

📚 Documentation & Support

Free Resources

🎥 Video Tutorials - Step-by-step video guides for all features
📖 Complete Documentation
💬 Discord Community - Active community, fast responses
🐛 GitHub Issues - Bug reports and feature requests

Premium Support

📧 Priority email support (response within 24 hours)
🎯 Feature requests prioritized
🚀 Early access to beta features

⚙️ Configuration & Settings

SQL Query Editor Layout Preferences

The SQL Query Editor is optimized for all screen sizes - from large multi-monitor setups to compact laptops.

Opening the SQL Query Editor

Keyboard Shortcuts:

Ctrl+Shift+Q (Mac: Cmd+Shift+Q) - Opens with your default layout preference
Ctrl+Shift+Alt+Q (Mac: Cmd+Shift+Alt+Q) - Opens side-by-side
Ctrl+K Ctrl+Q (Mac: Cmd+K Cmd+Q) - Choose layout interactively

Command Palette:

OneStream: Open SQL Query Editor - Default layout
OneStream: Open SQL Query Editor (Side by Side) - Opens beside current editor
OneStream: Open SQL Query Editor (Below) - Opens in new column below
OneStream: Open SQL Query Editor (Choose Layout) - Interactive menu

User Settings

Access via Settings → Extensions → OneStream SQL:

{
  // Default layout when opening SQL editor
  "onestream.sql.defaultLayout": "beside",
  // Options: "current" | "beside" | "below" | "active"

  // Start with schema sidebar collapsed (great for laptops)
  "onestream.sql.schemaSidebarCollapsed": true,

  // Use compact mode with smaller fonts (optimized for small screens)
  "onestream.sql.compactMode": true
}

For Multi-Monitor Setups

To open SQL editor in a separate window:

Open the SQL Query Editor (any layout)
Drag the tab out of VS Code, OR
Right-click the tab → "Move into New Window", OR
Press Ctrl+K O (Mac: Cmd+K O) while focused on the tab

The SQL editor stays fully functional and connected to your workspace even in a separate window!

Responsive Design

The SQL editor automatically adapts to your screen:

Large screens (1600px+): Full layout with expanded sidebar
Laptops (1366px): Compact layout, smaller sidebar
Small screens (1024px): Schema sidebar becomes an overlay
Tablet/Small (768px): Ultra-compact mobile-friendly layout
Height-aware: Adjusts editor heights for shorter screens

Pro Tip for Laptops: Enable compact mode and start with sidebar collapsed:

{
  "onestream.sql.schemaSidebarCollapsed": true,
  "onestream.sql.compactMode": true
}

❓ FAQ

Q: Does the free version expire? A: No! Free features are free forever. No trial, no expiration.

Q: What happens after the 14-day trial? A: If you don't cancel, you'll be charged $4.95/month. Cancel anytime during the trial to avoid charges. Free features always work regardless.

Q: Can I cancel anytime? A: Yes! Cancel through the license portal anytime. No questions asked.

Q: Do you support team/enterprise licenses? A: Yes! Contact us for volume pricing. Teams of 5+ get discounts.

Q: Does this work with Cursor IDE? A: Yes! Cursor uses VS Code engine. Full compatibility.

Q: Which OneStream versions are supported? A: OneStream 7.0+ is supported. IntelliSense works with 7.4, 8.0, and 9.0+.

Q: Can I use this offline? A: Free features work offline. Premium features require network access to OneStream environment.

Q: Will this slow down VS Code? A: No. The extension is highly optimized and uses minimal resources.

Q: Can multiple developers share one license? A: No. Each developer needs their own license. We offer team discounts for 5+ licenses.

Q: What if I have a problem during the trial? A: Join our Discord or email us. We respond quickly to trial users.

🎯 Common Use Cases

Use Case 1: Emergency Production Debugging

Scenario: CFO reports incorrect consolidation numbers. Deadline: 2 hours.

Without Premium:

Log into OneStream web interface
Navigate to error logs
Search through hundreds of errors
Copy stack traces to text file
Open SQL Management Studio
Write queries to investigate data
Export business rule
Debug in text editor
Re-import, test, repeat
Total time: 1.5-2 hours (if you're lucky)

With Premium:

See error notification in VS Code immediately
Click to view full stack trace (5 seconds)
Cmd+Shift+Q → Run SQL diagnostic queries with schema IntelliSense (2 min)
Edit rule directly in VS Code with C# IntelliSense (5 min)
Generate XML deployment package (10 seconds)
Test and deploy
Total time: 15-20 minutes

Time saved: 1+ hour when you need it most

Use Case 2: Daily Development Workflow

Scenario: Building new Finance Rule with complex SQL logic

Without Premium:

Write code in Business Rule Editor (no IntelliSense)
Guess at BRApi method names (or search docs)
Save rule, log out
Open SQL Management Studio
Test query logic
Switch back to Business Rule Editor
Make changes, save
Repeat 10-20 times per day
Wasted time: 2-3 hours daily

With Premium:

Write code in VS Code with full C# IntelliSense (works on Mac, Windows, Linux!)
api. → See all available methods instantly
Cmd+Shift+Q → Test SQL queries without leaving VS Code
Schema IntelliSense shows table/column names
Edit, test, refine in one interface
Wasted time: 20-30 minutes daily

Time saved: 1.5-2 hours per day = 7-10 hours per week

Use Case 3: Team Collaboration

Scenario: 3 developers working on the same application

Without Premium:

Developer A edits Finance Rule, exports XML
Developer B edits same rule (doesn't know A changed it)
Developer B deploys, overwrites A's work
A's changes are lost
Conflict resolution takes hours
No version history, no audit trail

With Premium + Git:

All developers pull rules from OneStream database
Each works in their own Git branch
Check sync status before deploying
Merge changes using Git workflows
Complete audit trail of who changed what
No more lost work, no more conflicts

Time saved: Countless hours of frustration + rework

🚀 What's Next?

Roadmap (Coming Soon)

✅ C# IntelliSense (Shipped in v5.2!)
🔄 Push rules to database (temporarily disabled, returning Q2 2025)
📊 Performance profiling for Finance Rules
🧪 Automated testing framework integration
📱 Mobile app for error monitoring
🔗 Slack/Teams integration for error notifications
🎨 Custom themes and layouts
📈 Analytics dashboard (rule complexity, execution time)

Premium subscribers get early access to all new features.

🤝 Community & Contribution

Join 500+ OneStream developers:

💬 Discord Server - Chat with other users, get help, share tips
🐛 Report Issues - Found a bug? Let us know
💡 Request Features - Tell us what you need
⭐ Star on GitHub - Show your support
📝 Write a Review - Help others discover this tool

📦 System Requirements

VS Code: Version 1.60.0 or higher
Cursor IDE: Any version
OneStream: Version 7.0 or higher (for premium features)
Network: Access to OneStream environment (for premium features)
OS: Windows, macOS, or Linux

📄 License & Legal

Extension: MIT License
Premium features: Subscription required
No affiliation with OneStream Software LLC
OneStream® is a registered trademark of OneStream Software LLC

Ready to Save 8+ Hours Per Week?

Try all premium features free for 14 days. Cancel anytime - no charge if you cancel.

Start Your Free Trial →

Already convinced?

Get Premium Now ($4.95/month) | Join Discord Community | View Documentation

⭐ 500+ developers trust OneStream Code Utility. Join them today. ⭐

Independent tool not affiliated with OneStream Software LLC. OneStream® is a registered trademark of OneStream Software LLC.

OneStream Code Utility

OnPointEPM

OneStream Code Utility

🎥 Watch How It Works

💰 The Real Cost of Context Switching

🎯 Real Developer, Real Results

⚡ See the Difference

❌ Before OneStream Code Utility

✅ After OneStream Code Utility (Premium)

🚀 Premium Features That Pay for Themselves in 10 Minutes

1. Task Activity Viewer 🆕

2. Real-Time Error Monitoring

3. SQL Query Editor with Schema Explorer

4. Rule Synchronization

5. C# IntelliSense for OneStream APIs ⭐ (Cross-Platform)

6. AI Assistant Integration (Beta)

7. OneStream Code Compilation 🆕

📊 Feature Comparison

💡 Who This Is For

Perfect for:

You'll Love This If:

🎁 Start Your 14-Day Free Trial

Get Started in 2 Minutes:

🛠️ Installation

VS Code

Cursor IDE

📖 Quick Start Guide

Free Features (No Trial Needed)

Premium Features (14-Day Free Trial)

💼 Pricing & Plans

Free Forever

Premium

Enterprise

🔒 Security & Privacy

📚 Documentation & Support

Free Resources

Premium Support

⚙️ Configuration & Settings

SQL Query Editor Layout Preferences

Opening the SQL Query Editor

User Settings

For Multi-Monitor Setups

Responsive Design

❓ FAQ

🎯 Common Use Cases

Use Case 1: Emergency Production Debugging

Use Case 2: Daily Development Workflow

Use Case 3: Team Collaboration

🚀 What's Next?

Roadmap (Coming Soon)

🤝 Community & Contribution

📦 System Requirements

📄 License & Legal

Ready to Save 8+ Hours Per Week?